Nile MCP Server
by Niledatabase
The Nile MCP Server is a Model Context Protocol (MCP) server implementation for the Nile database platform. It allows LLM applications to interact with Nile through a standardized interface, enabling database management, credential management, and SQL query execution.
Last updated: N/A
What is Nile MCP Server?
The Nile MCP Server is an implementation of the Model Context Protocol (MCP) designed to interface with the Nile database platform. It acts as a bridge between Large Language Model (LLM) applications and Nile, offering a standardized way to manage databases, access credentials, execute SQL queries, and more, all through natural language prompts.
How to use Nile MCP Server?
First, install the server using npm install @niledatabase/nile-mcp-server. Configure environment variables (NILE_API_KEY, NILE_WORKSPACE_SLUG) in a .env file. Then, start the server using either direct node execution (node dist/index.js) or development mode (npm run dev). Finally, configure Claude Desktop or Cursor to use the server by providing the path to the dist/index.js file and the necessary environment variables. Refer to the README for detailed instructions and example prompts.
Key features of Nile MCP Server
Database Management (create, list, get, delete)
Credential Management (create and list)
SQL Query Support
MCP Protocol Support
Type Safety (TypeScript)
Comprehensive Error Handling
Automatic Environment Variable Loading
Input Validation (Zod)
Use cases of Nile MCP Server
Database creation and management using natural language with LLMs
Executing SQL queries on Nile databases through LLM prompts
Managing database credentials via a standardized MCP interface
Integrating Nile databases with AI tools like Claude Desktop and Cursor
FAQ from Nile MCP Server
How do I configure the server?
How do I configure the server?
Create a .env file with your Nile API key and workspace slug. These credentials can be obtained from your Nile account.
How do I connect the server to Claude Desktop?
How do I connect the server to Claude Desktop?
Go to Settings > MCP Servers in Claude Desktop and add a new server. Provide the path to dist/index.js and configure the NILE_API_KEY and NILE_WORKSPACE_SLUG environment variables.
What SQL dialects are supported?
What SQL dialects are supported?
The server supports standard SQL that is compatible with the Nile database platform.
What regions are available for database creation?
What regions are available for database creation?
Currently, the available regions are AWS_US_WEST_2 (Oregon) and AWS_EU_CENTRAL_1 (Frankfurt).
How do I enable SSE mode?
How do I enable SSE mode?
Set MCP_SERVER_MODE=sse in your .env file. The server will start an HTTP server (default port 3000). Connect to the SSE endpoint: http://localhost:3000/sse. Send commands to: http://localhost:3000/messages