[{"_1":2,"_294":-5,"_295":-5},"loaderData",{"_3":4,"_53":54,"_55":56,"_57":58,"_239":240},"root",{"_5":6,"_49":50,"_51":52},"appGlobal",{"_7":8,"_38":39,"_40":41},"config",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":22,"_23":-5,"_24":25,"_26":27,"_28":29,"_30":31,"_32":33,"_34":31,"_35":31,"_36":37},"APP_URL","https://glama.ai","CLIENT_ASSETS_URL","https://static.glama.ai/client/","ENVIRONMENT","LIVE","FACEBOOK_PIXEL_ID","1988603181578092","GOOGLE_ANALYTICS_MEASUREMENT_ID","G-GDQ5NW5CB5","GOOGLE_OAUTH2_CLIENT_ID","48173796263-7ohlqirg28gh2a7nel61coff3m1ogjtc.apps.googleusercontent.com","INTERCOM_APP_ID","wgcqevfz","INTERCOM_USER_HASH","POSTHOG_API_KEY","phc_aK0RnJxBEBRE0h0LIz21yyc9w6ylBxwUHMPB4712Bjc","REDDIT_PIXEL_ID","a2_fcqsoymvje51","RELEASE_VERSION","glama@fe0ec19","SENTRY_DRY_RUN",false,"SENTRY_DSN","https://fc82aa9f808b13927ff29c56bda4d486@o4507975513735168.ingest.us.sentry.io/4507975514849280","SENTRY_SPOTLIGHT","SENTRY_TRACE","STRIPE_PUBLIC_KEY","pk_live_51QpZQ32LV3sZcHqzHlFuNhgSfggSNaQqCzZw9EMJ8tbhpQyZgcwQj1vz168FxQ35EGRcztKu2MankxiSs7zLCF4g00blUverGs","viewportWidth",1280,"visitorSession",{"_42":43,"_45":-5,"_46":47,"_48":-5},"attributes",[44],"BOT","membership","uid","H7xICREJni","userAccount","nonce","7a57d802d60822671a4b141638e4fd08","toasts",[],"routes/_public/_layout",{},"routes/_public/mcp/servers/~uid/_layout",{},"routes/_public/mcp/servers/~uid/_pages/_layout",{"_59":-5,"_60":61,"_157":158},"githubUser","mcpServer",{"_62":63,"_64":65,"_42":85,"_90":91,"_92":91,"_93":94,"_99":100,"_121":122,"_123":31,"_118":124,"_125":126,"_130":-5,"_131":-5,"_132":133,"_140":-5,"_141":142,"_147":-5,"_148":149,"_153":-5,"_46":154,"_155":156},"addedAt",["D",1741635232143],"argumentsJsonSchema",{"_66":67,"_68":69,"_72":73},"type","object","required",[70,71],"NILE_API_KEY","NILE_WORKSPACE_SLUG","properties",{"_70":74,"_78":79,"_71":83},{"_66":75,"_76":77},"string","description","Your Nile API key from console.thenile.dev","MCP_SERVER_MODE",{"_66":75,"_80":81,"_76":82},"default","stdio","Server operational mode: stdio (default) or sse",{"_66":75,"_76":84},"Your Nile workspace slug",[86,87,88,89],"author:official","category:databases","hosting:hybrid","language:typescript","descriptionMarkdown","MCP server for Nile Database - Manage and query databases, tenants, users, auth using LLMs","descriptionPlainText","githubProject",{"_95":96,"_97":98},"readme","

\n \n

Nile MCP Server\n
\n \n

\n Learn more ↗️\n
\n
\n Discord\n 🔵\n Website\n 🔵 \n Issues\n

\n\n[![smithery badge](https://smithery.ai/badge/@niledatabase/nile-mcp-server)](https://smithery.ai/server/@niledatabase/nile-mcp-server)\n\nA Model Context Protocol (MCP) server implementation for Nile database platform. This server allows LLM applications to interact with Nile platform through a standardized interface.\n\n## Features\n\n- **Database Management**: Create, list, get details, and delete databases\n- **Credential Management**: Create and list database credentials\n- **Region Management**: List available regions for database creation\n- **SQL Query Support**: Execute SQL queries directly on Nile databases\n- **MCP Protocol Support**: Full implementation of the Model Context Protocol\n- **Type Safety**: Written in TypeScript with full type checking\n- **Error Handling**: Comprehensive error handling and user-friendly error messages\n- **Test Coverage**: Comprehensive test suite using Jest\n- **Environment Management**: Automatic loading of environment variables from .env file\n- **Input Validation**: Schema-based input validation using Zod\n\n## Installation\n\nInstall the stable version:\n```bash\nnpm install @niledatabase/nile-mcp-server\n```\n\nFor the latest alpha/preview version:\n```bash\nnpm install @niledatabase/nile-mcp-server@alpha\n```\nThis will install @niledatabase/nile-mcp-server in your node_modules folder. For example: node_modules/@niledatabase/nile-mcp-server/dist/\n\n### Manual Installation\n```bash\n# Clone the repository\ngit clone https://github.com/yourusername/nile-mcp-server.git\ncd nile-mcp-server\n\n# Install dependencies\nnpm install\n\n# Build the project\nnpm run build\n```\n### Other mcp package managers\n1. npx @michaellatman/mcp-get@latest install @niledatabase/nile-mcp-server\n\n## Starting the Server\n\nThere are several ways to start the server:\n\n1. **Direct Node Execution**:\n ```bash\n node dist/index.js\n ```\n2. **Development Mode** (with auto-rebuild):\n ```bash\n npm run dev\n ```\n\nThe server will start and listen for MCP protocol messages. You should see startup logs indicating:\n- Environment variables loaded\n- Server instance created\n- Tools initialized\n- Transport connection established\n\nTo stop the server, press `Ctrl+C`.\n\n### Verifying the Server is Running\n\nWhen the server starts successfully, you should see logs similar to:\n```\n[info] Starting Nile MCP Server...\n[info] Loading environment variables...\n[info] Environment variables loaded successfully\n[info] Creating server instance...\n[info] Tools initialized successfully\n[info] Setting up stdio transport...\n[info] Server started successfully\n```\n\nIf you see these logs, the server is ready to accept commands from Claude Desktop.\n\n## Configuration\n\nCreate a `.env` file in the root directory with your Nile credentials:\n\n```env\nNILE_API_KEY=your_api_key_here\nNILE_WORKSPACE_SLUG=your_workspace_slug\n```\n\nTo create a Nile API key, log in to your [Nile account](console.thenile.dev), click Workspaces in the top-left, select your workspace, and navigate to the Security section in the left menu.\n\n## Using with Claude Desktop\n\n### Setup\n\n1. Install [Claude Desktop](https://claude.ai/desktop) if you haven't already\n2. Build the project:\n ```bash\n npm run build\n ```\n3. Open Claude Desktop\n4. Go to Settings > MCP Servers\n5. Click \"Add Server\"\n6. Add the following configuration:\n\n```json\n{\n \"mcpServers\": {\n \"nile-database\": {\n \"command\": \"node\",\n \"args\": [\n \"/path/to/your/nile-mcp-server/dist/index.js\"\n ],\n \"env\": {\n \"NILE_API_KEY\": \"your_api_key_here\",\n \"NILE_WORKSPACE_SLUG\": \"your_workspace_slug\"\n }\n }\n }\n}\n```\n\nReplace:\n- `/path/to/your/nile-mcp-server` with the absolute path to your project directory\n- `your_api_key_here` with your Nile API key\n- `your_workspace_slug` with your Nile workspace slug\n\n## Using with Cursor\n\n### Setup\n\n1. Install [Cursor](https://cursor.sh) if you haven't already\n2. Build the project:\n ```bash\n npm run build\n ```\n3. Open Cursor\n4. Go to Settings (⌘,) > Features > MCP Servers\n5. Click \"Add New MCP Server\"\n6. Configure the server:\n - Name: `nile-database` (or any name you prefer)\n - Command: \n ```bash\n env NILE_API_KEY=your_key NILE_WORKSPACE_SLUG=your_workspace node /absolute/path/to/nile-mcp-server/dist/index.js\n ```\n Replace:\n - `your_key` with your Nile API key\n - `your_workspace` with your Nile workspace slug\n - `/absolute/path/to` with the actual path to your project\n7. Click \"Save\"\n8. You should see a green indicator showing that the MCP server is connected\n9. Restart Cursor for the changes to take effect\n\n### Server Modes\n\nThe server supports two operational modes:\n\n#### STDIO Mode (Default)\nThe default mode uses standard input/output for communication, making it compatible with Claude Desktop and Cursor integrations.\n\n#### SSE Mode\nServer-Sent Events (SSE) mode enables real-time, event-driven communication over HTTP.\n\nTo enable SSE mode:\n1. Set `MCP_SERVER_MODE=sse` in your `.env` file\n2. The server will start an HTTP server (default port 3000)\n3. Connect to the SSE endpoint: `http://localhost:3000/sse`\n4. Send commands to: `http://localhost:3000/messages`\n\nExample SSE usage with curl:\n```bash\n# In terminal 1 - Listen for events\ncurl -N http://localhost:3000/sse\n\n# In terminal 2 - Send commands\ncurl -X POST http://localhost:3000/messages \\\n -H \"Content-Type: application/json\" \\\n -d '{\n \"type\": \"function\",\n \"name\": \"list-databases\",\n \"parameters\": {}\n }'\n```\n\n### Example Prompts\n\nAfter setting up the MCP server in Cursor, you can use natural language to interact with Nile databases. Here are some example prompts:\n\n#### Database Management\n```\nCreate a new database named \"my_app\" in AWS_US_WEST_2 region\n\nList all my databases\n\nGet details for database \"my_app\"\n\nDelete database \"test_db\"\n```\n\n#### Creating Tables\n```\nCreate a users table in my_app database with columns:\n- tenant_id (UUID, references tenants)\n- id (INTEGER)\n- email (VARCHAR, unique per tenant)\n- name (VARCHAR)\n- created_at (TIMESTAMP)\n\nCreate a products table in my_app database with columns:\n- tenant_id (UUID, references tenants)\n- id (INTEGER)\n- name (VARCHAR)\n- price (DECIMAL)\n- description (TEXT)\n- created_at (TIMESTAMP)\n```\n\n#### Querying Data\n```\nExecute this query on my_app database:\nSELECT * FROM users WHERE tenant_id = 'your-tenant-id' LIMIT 5\n\nRun this query on my_app:\nINSERT INTO users (tenant_id, id, email, name) \nVALUES ('tenant-id', 1, 'user@example.com', 'John Doe')\n\nShow me all products in my_app database with price > 100\n```\n\n#### Schema Management\n```\nShow me the schema for the users table in my_app database\n\nAdd a new column 'status' to the users table in my_app database\n\nCreate an index on the email column of the users table in my_app\n```\n\n### Available Tools\n\nThe server provides the following tools for interacting with Nile databases:\n\n#### Database Management\n\n1. **create-database**\n - Creates a new Nile database\n - Parameters:\n - `name` (string): Name of the database\n - `region` (string): Either `AWS_US_WEST_2` (Oregon) or `AWS_EU_CENTRAL_1` (Frankfurt)\n - Returns: Database details including ID, name, region, and status\n - Example: \"Create a database named 'my-app' in AWS_US_WEST_2\"\n\n2. **list-databases**\n - Lists all databases in your workspace\n - No parameters required\n - Returns: List of databases with their IDs, names, regions, and status\n - Example: \"List all my databases\"\n\n3. **get-database**\n - Gets detailed information about a specific database\n - Parameters:\n - `name` (string): Name of the database\n - Returns: Detailed database information including API host and DB host\n - Example: \"Get details for database 'my-app'\"\n\n4. **delete-database**\n - Deletes a database\n - Parameters:\n - `name` (string): Name of the database to delete\n - Returns: Confirmation message\n - Example: \"Delete database 'my-app'\"\n\n#### Credential Management\n\n1. **list-credentials**\n - Lists all credentials for a database\n - Parameters:\n - `databaseName` (string): Name of the database\n - Returns: List of credentials with IDs, usernames, and creation dates\n - Example: \"List credentials for database 'my-app'\"\n\n2. **create-credential**\n - Creates new credentials for a database\n - Parameters:\n - `databaseName` (string): Name of the database\n - Returns: New credential details including username and one-time password\n - Example: \"Create new credentials for database 'my-app'\"\n - Note: Save the password when it's displayed, as it won't be shown again\n\n#### Region Management\n\n1. **list-regions**\n - Lists all available regions for creating databases\n - No parameters required\n - Returns: List of available AWS regions\n - Example: \"What regions are available for creating databases?\"\n\n#### SQL Query Execution\n\n1. **execute-sql**\n - Executes SQL queries on a Nile database\n - Parameters:\n - `databaseName` (string): Name of the database to query\n - `query` (string): SQL query to execute\n - `connectionString` (string, optional): Pre-existing connection string to use for the query\n - Returns: Query results formatted as a markdown table with column headers and row count\n - Features:\n - Automatic credential management (creates new if not specified)\n - Secure SSL connection to database\n - Results formatted as markdown tables\n - Detailed error messages with hints\n - Support for using existing connection strings\n - Example: \"Execute SELECT * FROM users LIMIT 5 on database 'my-app'\"\n\n#### Resource Management\n\n1. **read-resource**\n - Reads schema information for database resources (tables, views, etc.)\n - Parameters:\n - `databaseName` (string): Name of the database\n - `resourceName` (string): Name of the resource (table/view)\n - Returns: Detailed schema information including:\n - Column names and types\n - Primary keys and indexes\n - Foreign key relationships\n - Column descriptions and constraints\n - Example: \"Show me the schema for the users table in my-app\"\n\n2. **list-resources**\n - Lists all resources (tables, views) in a database\n - Parameters:\n - `databaseName` (string): Name of the database\n - Returns: List of all resources with their types\n - Example: \"List all tables in my-app database\"\n\n#### Tenant Management\n\n1. **list-tenants**\n - Lists all tenants in a database\n - Parameters:\n - `databaseName` (string): Name of the database\n - Returns: List of tenants with their IDs and metadata\n - Example: \"Show all tenants in my-app database\"\n\n2. **create-tenant**\n - Creates a new tenant in a database\n - Parameters:\n - `databaseName` (string): Name of the database\n - `tenantName` (string): Name for the new tenant\n - Returns: New tenant details including ID\n - Example: \"Create a tenant named 'acme-corp' in my-app\"\n\n3. **delete-tenant**\n - Deletes tenants in the database\n - Parameters:\n - `databaseName` (string): Name of the database\n - `tenantName` (string): Name for the tenant\n - Returns: Success if the tenant is deleted\n - Example: \"Delete tenant named 'acme-corp' in my-app\"\n\n### Example Usage\n\nHere are some example commands you can use in Claude Desktop:\n\n```\n# Database Management\nPlease create a new database named \"my-app\" in the AWS_US_WEST_2 region.\nCan you list all my databases?\nGet the details for database \"my-app\".\nDelete the database named \"test-db\".\n\n# Connection String Management\nGet a connection string for database \"my-app\".\n# Connection string format: postgres://:@.db.thenile.dev:5432/\n# Example: postgres://cred-123:password@us-west-2.db.thenile.dev:5432/my-app\n\n# SQL Queries\nExecute SELECT * FROM users LIMIT 5 on database \"my-app\"\nRun this query on my-app database: SELECT COUNT(*) FROM orders WHERE status = 'completed'\nUsing connection string \"postgres://user:pass@host:5432/db\", execute this query on my-app: SELECT * FROM products WHERE price > 100\n```\n\n### Response Format\n\nAll tools return responses in a standardized format:\n- Success responses include relevant data and confirmation messages\n- Error responses include detailed error messages and HTTP status codes\n- SQL query results are formatted as markdown tables\n- All responses are formatted for easy reading in Claude Desktop\n\n### Error Handling\n\nThe server handles various error scenarios:\n- Invalid API credentials\n- Network connectivity issues\n- Invalid database names or regions\n- Missing required parameters\n- Database operation failures\n- SQL syntax errors with helpful hints\n- Rate limiting and API restrictions\n\n### Troubleshooting\n\n1. If Claude says it can't access the tools:\n - Check that the server path in the configuration is correct\n - Ensure the project is built (`npm run build`)\n - Verify your API key and workspace slug are correct\n - Restart Claude Desktop\n\n2. If database creation fails:\n - Check your API key permissions\n - Ensure the database name is unique in your workspace\n - Verify the region is one of the supported options\n\n3. If credential operations fail:\n - Verify the database exists and is in the READY state\n - Check that your API key has the necessary permissions\n\n## Development\n\n### Project Structure\n\n```\nnile-mcp-server/\n├── src/\n│ ├── server.ts # MCP server implementation\n│ ├── tools.ts # Tool implementations\n│ ├── types.ts # Type definitions\n│ ├── logger.ts # Logging utilities\n│ ├── index.ts # Entry point\n│ └── __tests__/ # Test files\n│ └── server.test.ts\n├── dist/ # Compiled JavaScript\n├── logs/ # Log files directory\n├── .env # Environment configuration\n├── .gitignore # Git ignore file\n├── package.json # Project dependencies\n└── tsconfig.json # TypeScript configuration\n```\n\n### Key Files\n\n- `server.ts`: Main server implementation with tool registration and transport handling\n- `tools.ts`: Implementation of all database operations and SQL query execution\n- `types.ts`: TypeScript interfaces for database operations and responses\n- `logger.ts`: Structured logging with daily rotation and debug support\n- `index.ts`: Server startup and environment configuration\n- `server.test.ts`: Comprehensive test suite for all functionality\n\n### Development\n\n```bash\n# Install dependencies\nnpm install\n\n# Build the project\nnpm run build\n\n# Start the server in production mode\nnode dist/index.js\n\n# Start the server using npm script\nnpm start\n\n# Start in development mode with auto-rebuild\nnpm run dev\n\n# Run tests\nnpm test\n```\n\n### Development Scripts\n\nThe following npm scripts are available:\n- `npm run build`: Compiles TypeScript to JavaScript\n- `npm start`: Starts the server in production mode\n- `npm run dev`: Starts the server in development mode with auto-rebuild\n- `npm test`: Runs the test suite\n- `npm run lint`: Runs ESLint for code quality checking\n- `npm run clean`: Removes build artifacts\n\n### Testing\n\nThe project includes a comprehensive test suite that covers:\n- Tool registration and schema validation\n- Database management operations\n- Connection string generation\n- SQL query execution and error handling\n- Response formatting and error cases\n\nRun the tests with:\n```bash\nnpm test\n```\n\n### Logging\n\nThe server uses structured logging with the following features:\n- Daily rotating log files\n- Separate debug logs\n- JSON formatted logs with timestamps\n- Console output for development\n- Log categories: info, error, debug, api, sql, startup\n\n## License\n\nMIT License - See [LICENSE](LICENSE) for details.\n\n## Related Links\n\n- [Model Context Protocol](https://modelcontextprotocol.io)\n- [Nile Database](https://thenile.dev)\n- [Claude Desktop](https://claude.ai/desktop)\n- [Cursor](https://cursor.sh) \n","url","https://github.com/niledatabase/nile-mcp-server","githubRepository",{"_101":102,"_103":104,"_105":106,"_107":108,"_109":110,"_114":115,"_116":117,"_120":115},"defaultBranch","alpha","fullName","niledatabase/nile-mcp-server","githubTreeId",79168,"language","TypeScript","owner",{"_111":112,"_113":31},"login","niledatabase","verified","recentStargazers",8,"spdxLicense",{"_118":119},"name","MIT License","stargazers","id",1754,"inspectable","nile-mcp","npmPackage",{"_118":127,"_128":129},"@niledatabase/nile-mcp-server","weeklyDownloads",661,"prompts","redditPostForeignId","relatedMcpServerIds",[134,135,136,137,138,139],1545,319,1236,751,1457,1313,"resources","scores",{"_143":144,"_145":-5,"_146":-5},"license",100,"quality","security","simpleIcon","supportedPlatforms",[150,151,152],"MACOS","WINDOWS","LINUX","tools","q6uaq3i3z7","updatedAt",["D",1741730532614],"meta",[159,162,164,171,174,176,179,182,185,188,191,193,196,199,201,203,205,207,209],{"_160":161},"title","nile-mcp | Glama",{"_163":91,"_118":76},"content",{"_165":166,"_167":168,"_169":170},"href","https://glama.ai/mcp/servers/q6uaq3i3z7","rel","canonical","tagName","link",{"_163":124,"_172":173},"property","og:title",{"_163":91,"_172":175},"og:description",{"_163":177,"_172":178},"https://glama.ai/logo.png","og:logo",{"_163":180,"_172":181},"https://glama.ai/mcp/servers/q6uaq3i3z7/og-image","og:image",{"_163":183,"_172":184},"630","og:image:height",{"_163":186,"_172":187},"1200","og:image:width",{"_163":189,"_172":190},"website","og:type",{"_163":166,"_172":192},"og:url",{"_163":194,"_172":195},"ChatGPT alternative for power users","og:site_name",{"_163":197,"_118":198},"summary_large_image","twitter:card",{"_163":194,"_118":200},"twitter:title",{"_163":91,"_118":202},"twitter:description",{"_163":180,"_118":204},"twitter:image",{"_163":183,"_118":206},"twitter:image:height",{"_163":186,"_118":208},"twitter:image:width",{"_210":211},"script:ld+json",{"_212":213,"_214":215},"@context","http://schema.org","@graph",[216],{"_212":217,"_218":219,"_220":221},"https://schema.org","@type","BreadcrumbList","itemListElement",[222,229,233,237],{"_218":223,"_224":225,"_118":226,"_227":228},"ListItem","item","https://glama.ai/","Glama","position",1,{"_218":223,"_224":230,"_118":231,"_227":232},"https://glama.ai/mcp","MCP",2,{"_218":223,"_224":234,"_118":235,"_227":236},"https://glama.ai/mcp/servers","Servers",3,{"_218":223,"_224":166,"_118":124,"_227":238},4,"routes/_public/mcp/servers/~uid/_pages/reviews/_route",{"_59":-5,"_60":241,"_157":259,"_293":-5},{"_62":242,"_64":243,"_42":249,"_90":91,"_92":91,"_93":250,"_99":251,"_121":122,"_123":31,"_118":124,"_125":254,"_130":-5,"_131":-5,"_132":255,"_140":-5,"_141":256,"_147":-5,"_148":257,"_153":-5,"_46":154,"_155":258},["D",1741635232143],{"_66":67,"_68":244,"_72":245},[70,71],{"_70":246,"_78":247,"_71":248},{"_66":75,"_76":77},{"_66":75,"_80":81,"_76":82},{"_66":75,"_76":84},[86,87,88,89],{"_95":96,"_97":98},{"_101":102,"_103":104,"_105":106,"_107":108,"_109":252,"_114":115,"_116":253,"_120":115},{"_111":112,"_113":31},{"_118":119},{"_118":127,"_128":129},[134,135,136,137,138,139],{"_143":144,"_145":-5,"_146":-5},[150,151,152],["D",1741730532614],[260,262,263,265,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281],{"_160":261},"Reviews | nile-mcp | Glama",{"_163":91,"_118":76},{"_165":264,"_167":168,"_169":170},"https://glama.ai/mcp/servers/q6uaq3i3z7/reviews",{"_163":266,"_172":173},"Reviews | nile-mcp",{"_163":91,"_172":175},{"_163":177,"_172":178},{"_163":180,"_172":181},{"_163":183,"_172":184},{"_163":186,"_172":187},{"_163":189,"_172":190},{"_163":264,"_172":192},{"_163":194,"_172":195},{"_163":197,"_118":198},{"_163":194,"_118":200},{"_163":91,"_118":202},{"_163":180,"_118":204},{"_163":183,"_118":206},{"_163":186,"_118":208},{"_210":282},{"_212":213,"_214":283},[284],{"_212":217,"_218":219,"_220":285},[286,287,288,289,290],{"_218":223,"_224":225,"_118":226,"_227":228},{"_218":223,"_224":230,"_118":231,"_227":232},{"_218":223,"_224":234,"_118":235,"_227":236},{"_218":223,"_224":166,"_118":124,"_227":238},{"_218":223,"_224":264,"_118":291,"_227":292},"Reviews",5,"review","actionData","errors"]

Nile MCP Server\n \n \n

Nile MCP Server\n
\n \n

Rate & Review