Nile Database MCP Server

DatabasesTypeScript

Manage and query Nile databases, tenants, users, and authentication using LLMs

Available Tools

listDatabases

List all databases in your Nile workspace

createDatabase

Create a new database in your Nile workspace

getDatabase

Get details about a specific database

deleteDatabase

Delete a database from your Nile workspace

listRegions

List available regions for database creation

createCredentials

Create new database credentials

listCredentials

List all database credentials

executeSQL

Execute SQL queries directly on Nile databases

Nile Database MCP Server provides a seamless interface for LLM applications to interact with the Nile database platform. It enables AI assistants to create and manage databases, handle credentials, execute SQL queries, and manage multi-tenant applications directly through natural language. With this integration, developers can leverage the power of LLMs to streamline database operations, reducing the need to switch between interfaces when working with Nile's serverless Postgres platform. The server implements the full Model Context Protocol specification, ensuring compatibility with various LLM clients.

Overview

The Nile Database MCP Server allows AI assistants to interact with Nile's serverless Postgres platform. This integration enables you to manage databases, execute SQL queries, handle credentials, and work with multi-tenant applications through natural language conversations.

Installation

You can install the Nile Database MCP Server using npm:

# Install stable version
npm install @niledatabase/nile-mcp-server

# For latest alpha/preview version
npm install @niledatabase/nile-mcp-server@alpha

Alternatively, you can use other MCP package managers:

npx @michaellatman/mcp-get@latest install @niledatabase/nile-mcp-server

For manual installation:

# Clone the repository
git clone https://github.com/niledatabase/nile-mcp-server.git
cd nile-mcp-server

# Install dependencies
npm install

# Build the project
npm run build

Configuration

Before using the server, you need to set up your Nile credentials. Create a .env file in the root directory with:

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 at console.thenile.dev
Click Workspaces in the top-left
Select your workspace
Navigate to the Security section in the left menu
Generate a new API key

Using with Claude Desktop

Build the project with npm run build
Open Claude Desktop
Go to Settings > MCP Servers
Click "Add Server"
Add the configuration as shown in the installation section below

Using with Cursor

Build the project with npm run build
Open Cursor
Go to Settings (⌘,) > Features > MCP Servers
Click "Add New MCP Server"
Name it "nile-database" (or any name you prefer)

Set the command to:

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

Click "Save"
Restart Cursor for the changes to take effect

Server Modes

The server supports two operational modes:

STDIO Mode (Default)

Uses standard input/output for communication, making it compatible with Claude Desktop and Cursor integrations.

SSE Mode

Server-Sent Events (SSE) mode enables real-time, event-driven communication over HTTP.

Troubleshooting

If you encounter issues:

Verify your API key and workspace slug are correct
Check that the server is running (you should see startup logs)
Ensure the path to the server in your configuration is correct
Restart your LLM client after making configuration changes

For more information, visit the Nile documentation or join the Discord community.