Manages and queries Nile Postgres databases, tenants, users and auth settings through MCP tools.
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add nile --env NILE_API_KEY='<NILE_API_KEY>' --env NILE_WORKSPACE_SLUG='<NILE_WORKSPACE_SLUG>' -- node dist/index.js~/.codex/config.toml
[mcp_servers.nile]
command = "node"
args = ["dist/index.js"]
env = { NILE_API_KEY = "<NILE_API_KEY>", NILE_WORKSPACE_SLUG = "<NILE_WORKSPACE_SLUG>" }
# codex mcp add nile --env NILE_API_KEY='<NILE_API_KEY>' --env NILE_WORKSPACE_SLUG='<NILE_WORKSPACE_SLUG>' -- node dist/index.js~/.cursor/mcp.json
{
"mcpServers": {
"nile": {
"command": "node",
"args": [
"dist/index.js"
],
"env": {
"NILE_API_KEY": "<NILE_API_KEY>",
"NILE_WORKSPACE_SLUG": "<NILE_WORKSPACE_SLUG>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"nile": {
"type": "stdio",
"command": "node",
"args": [
"dist/index.js"
],
"env": {
"NILE_API_KEY": "<NILE_API_KEY>",
"NILE_WORKSPACE_SLUG": "<NILE_WORKSPACE_SLUG>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"nile": {
"command": "node",
"args": [
"dist/index.js"
],
"env": {
"NILE_API_KEY": "<NILE_API_KEY>",
"NILE_WORKSPACE_SLUG": "<NILE_WORKSPACE_SLUG>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"nile": {
"command": "node",
"args": [
"dist/index.js"
],
"env": {
"NILE_API_KEY": "<NILE_API_KEY>",
"NILE_WORKSPACE_SLUG": "<NILE_WORKSPACE_SLUG>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"nile": {
"command": "node",
"args": [
"dist/index.js"
],
"env": {
"NILE_API_KEY": "<NILE_API_KEY>",
"NILE_WORKSPACE_SLUG": "<NILE_WORKSPACE_SLUG>"
}
}
}
}Environment variables
NILE_API_KEYNILE_WORKSPACE_SLUG
Replace the placeholders with your own credentials and keep them out of version control.