Nile MCP Server integrates AI assistants with the Nile serverless PostgreSQL database platform, enabling complete database lifecycle management and SQL execution through a standardized interface. Key capabilities include: - **Database Management**: Create, list, retrieve details, and delete databases programmatically through natural language commands. - **SQL Query Execution**: Execute SQL queries directly against Nile databases with full PostgreSQL compatibility. - **Credential & Region Management**: Generate database credentials securely and provision databases across available geographical regions. - **MCP Protocol Implementation**: Full Model Context Protocol support with TypeScript-based type safety, Zod input validation, and comprehensive error handling.

Nile MCP Server Learn more ↗️ Discord 🔵 Website 🔵 Issues

[](https://smithery.ai/server/@niledatabase/nile-mcp-server)

A Model Context Protocol (MCP) server implementation for Nile database platform. This server allows LLM applications to interact with Nile platform through a standardized interface.

Features

Installation

Install the stable version:

npm install @niledatabase/nile-mcp-server

For the latest alpha/preview version:

npm install @niledatabase/nile-mcp-server@alpha

Manual Installation

# Clone the repository
git clone https://github.com/yourusername/nile-mcp-server.git
cd nile-mcp-server
Install dependencies
npm install
Build the project
npm run build

Other mcp package managers

Starting the Server

There are several ways to start the server:

1. Direct Node Execution:

   node dist/index.js
   

   npm run dev
   

The server will start and listen for MCP protocol messages. You should see startup logs indicating:

To stop the server, press Ctrl+C.

Verifying the Server is Running

When the server starts successfully, you should see logs similar to:

[info] Starting Nile MCP Server...
[info] Loading environment variables...
[info] Environment variables loaded successfully
[info] Creating server instance...
[info] Tools initialized successfully
[info] Setting up stdio transport...
[info] Server started successfully

If you see these logs, the server is ready to accept commands from Claude Desktop.

Configuration

Create a .env file in the root directory with your Nile credentials:

NILE_API_KEY=your_api_key_here
NILE_WORKSPACE_SLUG=your_workspace_slug

To create a Nile API key, log in to your Nile account, click Workspaces in the top-left, select your workspace, and navigate to the Security section in the left menu.

Using with Claude Desktop

Setup

1. Install Claude Desktop if you haven't already 2. Build the project:

   npm run build
   

{
  "mcpServers": {
    "nile-database": {
      "command": "node",
      "args": [
        "/path/to/your/nile-mcp-server/dist/index.js"
      ],
      "env": {
        "NILE_API_KEY": "your_api_key_here",
        "NILE_WORKSPACE_SLUG": "your_workspace_slug"
      }
    }
  }
}

Replace:

Using with Cursor

Setup

1. Install Cursor if you haven't already 2. Build the project:

   npm run build
   

     env NILE_API_KEY=your_key NILE_WORKSPACE_SLUG=your_workspace node /absolute/path/to/nile-mcp-server/dist/index.js