Nile Postgres

Nile Postgres is an MCP server that connects Model Context Protocol clients such as Claude Desktop and Cursor directly to the Nile database platform. It is designed for software engineers and database administrators who build multi-tenant applications and need AI assistance to manage database infrastructure and execute queries. The server allows language models to interact with Nile workspaces through standardized tools without manual intervention in web dashboards. Users can provision new Postgres databases across supported AWS regions, delete obsolete instances, list existing databases, and inspect runtime host configurations. The server also manages database credentials by issuing administrative usernames and passwords on demand. For database development, the server exposes tools to inspect schema definitions, column constraints, indexes, and foreign keys across tables and views. It supports running SQL queries directly over secure SSL connections, returning tabular query outputs for automated schema migrations, data analysis, and user management. Additionally, the server provides dedicated tenant tools to create and list tenants within multi-tenant schemas.

Category: Databases & Data Stores

Tags: authentication, multi-tenancy, postgres, SQL

Visit Nile Postgres

How to install and configure Nile Postgres

1. Install the server package using npm: bash npm install @niledatabase/nile-mcp-server 2. Obtain your API key and workspace slug from the Security section of your Nile workspace console. 3. Open your MCP client configuration file, such as Claude Desktop's claude_desktop_config.json. 4. Add the server entry under the mcpServers object: json { "mcpServers": { "nile-database": { "command": "node", "args": [ "/path/to/node_modules/@niledatabase/nile-mcp-server/dist/index.js" ], "env": { "NILE_API_KEY": "your_api_key_here", "NILE_WORKSPACE_SLUG": "your_workspace_slug" } } } } 5. Replace the path with the absolute path to your installed dist/index.js file and provide your credentials. 6. Restart your MCP client to enable the Nile tools.

What you can do with Nile Postgres

• Provisioning new multi-tenant Nile Postgres databases in specific AWS regions directly through natural language prompts in your IDE or conversational client. * Inspecting database schemas, column data types, table constraints, and foreign key relationships across existing tables and views without opening an external SQL GUI. * Executing SQL queries and data updates securely over SSL, viewing formatted markdown tables of database results inside Claude Desktop or Cursor. * Generating and retrieving temporary database user credentials and administrative access details automatically during local development and testing workflows. * Listing and administering tenants across multi-tenant database partitions to verify user separation and inspect tenant-level application data directly.

Key facts

• https://github.com/niledatabase/nile-mcp-server
• Databases & Data Stores, Developer Tools & Code Intelligence
• authentication, multi-tenancy, postgres, SQL

Part of MCP Servers

How do I install Nile Postgres?

You can install it using npm by running npm install @niledatabase/nile-mcp-server or by cloning the repository and running npm install followed by npm run build. It can also be installed through mcp-get using npx @michaellatman/mcp-get@latest install @niledatabase/nile-mcp-server.

What can Nile Postgres do?

The server lets your LLM client create, list, inspect, and delete Nile databases. It allows you to generate database credentials, list available deployment regions, inspect table schemas and views, execute arbitrary SQL queries over SSL, and manage multi-tenant database instances.

Which MCP clients work with Nile Postgres?

Nile Postgres works with any client supporting the Model Context Protocol over stdio or Server-Sent Events (SSE). It has documented configuration setups for Claude Desktop and Cursor, and it can also accept commands via HTTP when running in SSE mode.

What environment variables are required to configure Nile Postgres?

You must configure NILE_API_KEY and NILE_WORKSPACE_SLUG in your client configuration or within a local .env file. You can generate the API key in your Nile account dashboard by selecting your workspace and accessing the Security menu.