Loading...
Nile MCP Server enables LLM applications to interact with Nile databases via a standardized interface, offering database management, SQL query execution, and credential management.
Boost this tool
Subscribe to listing upgrades or segmented pushes.
Nile MCP Server enables LLM applications to interact with Nile databases via a standardized interface, offering database management, SQL query execution, and credential management.
The Nile MCP Server provides a convenient interface for interacting with Nile databases, but it also introduces risks due to its ability to execute SQL queries and manage database resources. It is safe to use in environments where input is carefully validated and access is restricted. It is risky if exposed to untrusted users or if proper security measures are not in place.
Performance depends on the complexity of SQL queries and the size of the database. Consider optimizing queries for better performance.
Cost depends on the usage of Nile database resources, including storage, compute, and network traffic. Monitor usage to avoid unexpected costs.
npm install @niledatabase/nile-mcp-server{
"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"
}
}
}
}NILE_API_KEYNILE_WORKSPACE_SLUGMCP_SERVER_MODEcreate-databaseCreates a new Nile database in a specified region.
Creates new databases, potentially consuming resources.
list-databasesLists all databases in your workspace.
Read-only operation, no side effects.
get-databaseGets detailed information about a specific database.
Read-only operation, no side effects.
delete-databaseDeletes a database.
Destructive operation, can lead to data loss.
list-credentialsLists all credentials for a database.
Read-only operation, no side effects.
create-credentialCreates new credentials for a database.
Creates new credentials, potentially granting access.
list-regionsLists all available regions for creating databases.
Read-only operation, no side effects.
execute-sqlExecutes SQL queries on a Nile database.
Can modify or delete data, depending on the query.
read-resourceReads schema information for database resources (tables, views, etc.).
Read-only operation, no side effects.
list-resourcesLists all resources (tables, views) in a database.
Read-only operation, no side effects.
list-tenantsLists all tenants in a database.
Read-only operation, no side effects.
create-tenantCreates a new tenant in a database.
Creates new tenants, potentially consuming resources.
delete-tenantDeletes tenants in the database.
Destructive operation, can lead to data loss.
Environment Variable
hybrid
The Nile MCP Server provides a convenient interface for interacting with Nile databases, but it also introduces risks due to its ability to execute SQL queries and manage database resources. It is safe to use in environments where input is carefully validated and access is restricted. It is risky if exposed to untrusted users or if proper security measures are not in place.
The server provides full access to the Nile database platform, so caution is advised when granting autonomy. There is no built-in sandboxing or rollback support.
Production Tip
Securely manage and rotate API keys to prevent unauthorized access.
Log in to your Nile account, click Workspaces, select your workspace, and navigate to the Security section.
Set MCP_SERVER_MODE=sse in your .env file and connect to http://localhost:3000/sse.
The available regions are AWS_US_WEST_2 (Oregon) and AWS_EU_CENTRAL_1 (Frankfurt).
Use the execute-sql tool with the database name and the SQL query as parameters.
Use the list-resources tool with the database name as a parameter.
Use the read-resource tool with the database name and table name as parameters.
The default mode is STDIO, which is compatible with Claude Desktop and Cursor integrations.