{"_id":"@athenaintelligence/mcp-server-athena-neon","_rev":"2-ddeddac9c631d966a4aa707664332b50","name":"@athenaintelligence/mcp-server-athena-neon","dist-tags":{"latest":"0.1.1"},"versions":{"0.1.0":{"name":"@athenaintelligence/mcp-server-athena-neon","version":"0.1.0","keywords":["mcp","model-context-protocol","neon","postgresql","postgres","database","self-hosted","ai","claude","llm"],"author":{"name":"Athena Intelligence"},"license":"MIT","_id":"@athenaintelligence/mcp-server-athena-neon@0.1.0","maintainers":[{"name":"brendongeils","email":"brendon@athenaintel.com"}],"homepage":"https://github.com/bgeils/neon-self-hosted-investigation/tree/main/mcp-server#readme","bugs":{"url":"https://github.com/bgeils/neon-self-hosted-investigation/issues"},"bin":{"mcp-server-athena-neon":"dist/cli.js"},"dist":{"shasum":"1c1a3a7bf20e577dc6e94d026e05f50f86cd56a3","tarball":"https://registry.npmjs.org/@athenaintelligence/mcp-server-athena-neon/-/mcp-server-athena-neon-0.1.0.tgz","fileCount":42,"integrity":"sha512-TUaWQzq7jkKYUPLjB7jjaeKr0KxMwYxu/lSDciyQobiWjSQ9/QKFDBuaTMfD6QTjf2QH8Y829mT4XzgeNwmv/A==","signatures":[{"sig":"MEUCIC96RhvbbMMMEc+enzH0ppKd6OZuU1lH9sn2YsAgZH2FAiEA7dGQt+xf0UTXuWwpBdyCB/NlAmNnqoVpgIRNEpkq5cc=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":86402},"main":"dist/index.js","type":"module","types":"dist/index.d.ts","engines":{"node":">=18.0.0"},"gitHead":"d642bc73a13e92a2c6e3e37b1e6c8d63de735664","scripts":{"dev":"tsc --watch","lint":"eslint src --ext .ts","build":"tsc","clean":"rm -rf dist","start":"node dist/cli.js","prepublishOnly":"npm run build"},"_npmUser":{"name":"brendongeils","email":"brendon@athenaintel.com"},"repository":{"url":"git+https://github.com/bgeils/neon-self-hosted-investigation.git","type":"git","directory":"mcp-server"},"_npmVersion":"10.9.2","description":"MCP server for self-hosted Neon PostgreSQL - enables AI assistants to manage databases via natural language","directories":{},"_nodeVersion":"22.17.1","dependencies":{"zod":"^3.22.4","@modelcontextprotocol/sdk":"^1.0.0"},"publishConfig":{"access":"public"},"_hasShrinkwrap":false,"devDependencies":{"typescript":"^5.3.0","@types/node":"^20.10.0"},"_npmOperationalInternal":{"tmp":"tmp/mcp-server-athena-neon_0.1.0_1767706157605_0.7354134214632364","host":"s3://npm-registry-packages-npm-production"}},"0.1.1":{"name":"@athenaintelligence/mcp-server-athena-neon","version":"0.1.1","description":"MCP server for self-hosted Neon PostgreSQL - enables AI assistants to manage databases via natural language","type":"module","main":"dist/index.js","types":"dist/index.d.ts","bin":{"mcp-server-athena-neon":"dist/cli.js"},"scripts":{"build":"tsc","dev":"tsc --watch","start":"node dist/cli.js","prepublishOnly":"npm run build","lint":"eslint src --ext .ts","clean":"rm -rf dist"},"dependencies":{"@modelcontextprotocol/sdk":"^1.0.0","zod":"^3.22.4"},"devDependencies":{"@types/node":"^20.10.0","typescript":"^5.3.0"},"engines":{"node":">=18.0.0"},"keywords":["mcp","model-context-protocol","neon","postgresql","postgres","database","self-hosted","ai","claude","llm"],"author":{"name":"Athena Intelligence"},"license":"MIT","repository":{"type":"git","url":"git+https://github.com/bgeils/neon-self-hosted-investigation.git","directory":"mcp-server"},"homepage":"https://github.com/bgeils/neon-self-hosted-investigation/tree/main/mcp-server#readme","bugs":{"url":"https://github.com/bgeils/neon-self-hosted-investigation/issues"},"publishConfig":{"access":"public"},"_id":"@athenaintelligence/mcp-server-athena-neon@0.1.1","gitHead":"b31ee4c6c587042593ebb49ddd712752a4d54a13","_nodeVersion":"22.17.1","_npmVersion":"10.5.2","dist":{"integrity":"sha512-fLjlfubKccA1XojvcMkedCOUL7vG2JbNIbsA9DtHHyxMVRtoYqJzopmvPrhR80Z47BJQ3g8DQ4NUZbGMJla7LA==","shasum":"51ec261d3c4253b8965b83dbc0c2f859fc1e23f5","tarball":"https://registry.npmjs.org/@athenaintelligence/mcp-server-athena-neon/-/mcp-server-athena-neon-0.1.1.tgz","fileCount":42,"unpackedSize":87737,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIQDQ3oVipHA7sBhs+ZLDpoa9II8coAHCuaRmvvwP/nwUQgIgNCorz6ACK0wPNl7IFTfJHcI5CG9pQZAV8EGQWI7rHt0="}]},"_npmUser":{"name":"brendongeils","email":"brendon@athenaintel.com"},"directories":{},"maintainers":[{"name":"brendongeils","email":"brendon@athenaintel.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/mcp-server-athena-neon_0.1.1_1767823050732_0.002090951369477123"},"_hasShrinkwrap":false}},"time":{"created":"2026-01-06T13:29:17.477Z","modified":"2026-01-07T21:57:31.159Z","0.1.0":"2026-01-06T13:29:17.770Z","0.1.1":"2026-01-07T21:57:30.914Z"},"bugs":{"url":"https://github.com/bgeils/neon-self-hosted-investigation/issues"},"author":{"name":"Athena Intelligence"},"license":"MIT","homepage":"https://github.com/bgeils/neon-self-hosted-investigation/tree/main/mcp-server#readme","keywords":["mcp","model-context-protocol","neon","postgresql","postgres","database","self-hosted","ai","claude","llm"],"repository":{"type":"git","url":"git+https://github.com/bgeils/neon-self-hosted-investigation.git","directory":"mcp-server"},"description":"MCP server for self-hosted Neon PostgreSQL - enables AI assistants to manage databases via natural language","maintainers":[{"name":"brendongeils","email":"brendon@athenaintel.com"}],"readme":"# @athenaintelligence/mcp-server-athena-neon\n\nAn MCP (Model Context Protocol) server for managing self-hosted Neon PostgreSQL deployments. This server allows AI assistants like Claude to interact with your Neon databases using natural language.\n\n[![npm version](https://badge.fury.io/js/@athenaintelligence%2Fmcp-server-athena-neon.svg)](https://www.npmjs.com/package/@athenaintelligence/mcp-server-athena-neon)\n\n## Features\n\n- **Database Management**: Create, list, describe, and delete databases\n- **SQL Execution**: Run queries and explore database schemas\n- **Compute Control**: Start and suspend compute instances\n- **Branch Management**: Create and manage database branches for development/testing\n\n## Installation\n\n```bash\nnpm install -g @athenaintelligence/mcp-server-athena-neon\n```\n\nOr use directly with npx:\n\n```bash\nnpx @athenaintelligence/mcp-server-athena-neon start http://your-neon-host:8080\n```\n\n## Usage\n\n### Starting the Server\n\n```bash\n# With explicit URL\nmcp-server-athena-neon start http://localhost:8080\n\n# With API key\nmcp-server-athena-neon start https://neon.example.com your-api-key\n\n# Using environment variables\nNEON_BASE_URL=http://localhost:8080 mcp-server-athena-neon start\n```\n\n### Claude Desktop Setup\n\n#### Step 1: Locate your config file\n\n| OS | Config File Location |\n|----|---------------------|\n| macOS | `~/Library/Application Support/Claude/claude_desktop_config.json` |\n| Windows | `%APPDATA%\\Claude\\claude_desktop_config.json` |\n| Linux | `~/.config/Claude/claude_desktop_config.json` |\n\n#### Step 2: Add the MCP server configuration\n\nOpen the config file and add the following (create the file if it doesn't exist):\n\n```json\n{\n  \"mcpServers\": {\n    \"athena-neon\": {\n      \"command\": \"npx\",\n      \"args\": [\n        \"-y\",\n        \"@athenaintelligence/mcp-server-athena-neon\",\n        \"start\",\n        \"https://your-neon-control-plane.example.com\",\n        \"YOUR_API_KEY\"\n      ]\n    }\n  }\n}\n```\n\n**Getting your API key:**\n1. Navigate to your Neon control plane (e.g., `https://your-neon-control-plane.example.com/settings`)\n2. Go to Settings → API Keys\n3. Click \"Create API Key\"\n4. Copy the key and add it as the fourth argument above\n\n**Example with Athena staging (with API key):**\n\n```json\n{\n  \"mcpServers\": {\n    \"athena-neon\": {\n      \"command\": \"npx\",\n      \"args\": [\n        \"-y\",\n        \"@athenaintelligence/mcp-server-athena-neon\",\n        \"start\",\n        \"https://neon-aws-staging.athenaintel.com\",\n        \"YOUR_API_KEY\"\n      ]\n    }\n  }\n}\n```\n\n**Note:** Get your API key from the Settings page at https://neon-aws-staging.athenaintel.com/settings\n\n#### Step 3: Restart Claude Desktop\n\nCompletely quit and reopen Claude Desktop for the changes to take effect.\n\n#### Step 4: Verify it's working\n\nIn Claude Desktop, you should see a hammer icon (🔨) in the input area indicating MCP tools are available. Try asking:\n\n> \"List all my Neon databases\"\n\n#### Troubleshooting\n\n- **Tools not appearing?** Make sure Node.js >= 18 is installed and in your PATH\n- **Connection errors?** Verify the control plane URL is accessible from your machine\n- **Permission errors?** Check that the config file is valid JSON\n\n## Available Tools\n\n### Database Management\n\n| Tool | Description |\n|------|-------------|\n| `list_databases` | List all databases in the deployment |\n| `describe_database` | Get detailed info about a specific database |\n| `create_database` | Create a new database |\n| `delete_database` | Delete a database |\n| `get_connection_string` | Get PostgreSQL connection string |\n\n### SQL Execution\n\n| Tool | Description |\n|------|-------------|\n| `run_sql` | Execute SQL queries |\n| `get_database_tables` | List tables in a schema |\n| `describe_table_schema` | Get column definitions for a table |\n| `list_schemas` | List schemas in a database |\n\n### Compute Management\n\n| Tool | Description |\n|------|-------------|\n| `get_compute_status` | Get compute instance status |\n| `start_compute` | Resume a suspended compute |\n| `suspend_compute` | Suspend a running compute |\n\n### Branch Management\n\n| Tool | Description |\n|------|-------------|\n| `list_branches` | List branches for a database |\n| `describe_branch` | Get branch details |\n| `create_branch` | Create a new branch |\n| `delete_branch` | Delete a branch |\n\n## Example Interactions\n\nOnce configured, you can ask Claude things like:\n\n- \"List all my Neon databases\"\n- \"Create a new database called 'myapp'\"\n- \"Show me all tables in the orders database\"\n- \"Run this query: SELECT * FROM users LIMIT 10\"\n- \"Suspend the compute for the test-db database\"\n- \"Create a branch called 'feature-test' from the main database\"\n\n## Development\n\n```bash\n# Install dependencies\nnpm install\n\n# Build\nnpm run build\n\n# Watch mode\nnpm run dev\n\n# Run locally\nnpm start -- start http://localhost:8080\n```\n\n## Architecture\n\n```\nMCP Client (Claude Desktop, etc.)\n         │\n         │ MCP Protocol (stdio)\n         ▼\n┌─────────────────────────────┐\n│   MCP Server (this package) │\n│   - Tool definitions        │\n│   - Request handling        │\n└─────────────────────────────┘\n         │\n         │ HTTP REST\n         ▼\n┌─────────────────────────────┐\n│   Neon Control Plane API    │\n│   /api/v1/...               │\n└─────────────────────────────┘\n         │\n         ▼\n    [Your Neon Databases]\n```\n\n## Requirements\n\n- Node.js >= 18.0.0\n- A running self-hosted Neon deployment with control plane API\n\n## License\n\nMIT\n","readmeFilename":"README.md"}