Best for
- Developers and non-developers who want to manage Neon databases via natural language.
- Users who want to perform database tasks quickly within IDEs or chat interfaces.
- Teams needing safe migrations and query optimization.
N
Neon MCP Server
Official
Interact with your Lakebase Postgres databases on Neon using natural language.
GitHub source repository ↗
73FMRS · B
Official Neon MCP server supporting remote hosted and local development, with comprehensive features covering project management, branching, SQL queries, migrations, optimization, authentication, and data API. Suitable for managing Neon databases via natural language, but security considerations must be addressed.
The Neon MCP Server is an open-source tool from Neon that lets you interact with your Lakebase Postgres databases on Neon in natural language. It acts as a bridge between natural language requests and the Neon API, translating your requests into necessary API calls. This enables you to manage projects, branches, run queries, and perform database migrations seamlessly. It offers a remote hosted server with OAuth or API key authentication, as well as local development options.
Tools
list_projects
Lists the first 10 Neon projects in your account.
list_shared_projects
Lists Neon projects shared with the current user.
describe_project
Fetches detailed information about a specific Neon project.
create_project
Creates a new Neon project in your account.
delete_project
Deletes an existing Neon project and all associated resources.
list_organizations
Lists all organizations the current user has access to.
create_branch
Creates a new branch within a specified Neon project.
delete_branch
Deletes an existing branch from a Neon project.
describe_branch
Retrieves details about a specific branch.
list_branch_computes
Lists compute endpoints for a project or branch.
compare_database_schema
Shows schema diff between child branch and parent.
reset_from_parent
Resets the current branch to its parent's state.
get_connection_string
Returns your database connection string.
run_sql
Executes a single SQL query against a Neon database.
run_sql_transaction
Executes a series of SQL queries within a single transaction.
get_database_tables
Lists all tables within a specified Neon database.
describe_table_schema
Retrieves schema definition of a specific table.
prepare_database_migration
Initiates a migration, creating a temporary branch for safe testing.
complete_database_migration
Finalizes and applies a prepared migration to the main branch.
list_slow_queries
Identifies slowest queries in a database.
explain_sql_statement
Provides detailed execution plans for SQL queries.
prepare_query_tuning
Analyzes query performance and suggests optimizations, creating a temporary branch.
complete_query_tuning
Finalizes query tuning by applying or discarding optimizations.
provision_neon_auth
Provisions Neon Auth for a project.
configure_neon_auth
Configures an existing Neon Auth integration.
get_neon_auth_config
Reads Neon Auth configuration for a branch.
provision_neon_data_api
Provisions the Neon Data API for HTTP-based access.
search
Searches across organizations, projects, and branches.
fetch
Fetches detailed information about a specific entity.
query_logs
Queries logs emitted by serverless functions.
list_log_fields
Lists log fields you can filter on.
list_log_field_values
Lists distinct values of a log field.
list_docs_resources
Lists all available Neon documentation pages.
get_doc_resource
Fetches a specific documentation page as markdown.
Setup
- Install an MCP client (e.g., Claude Desktop, Cursor).
- Connect to the remote server using OAuth or API key:
- OAuth: Run npx add-mcp https://mcp.neon.tech/mcp or configure {"mcpServers":{"Neon":{"type":"http","url":"https://mcp.neon.tech/mcp"}}} and follow the browser OAuth flow.
- API key: Create a Neon API key and configure {"mcpServers":{"Neon":{"type":"http","url":"https://mcp.neon.tech/mcp","headers":{"Authorization":"Bearer <API_KEY>"}}}}.
- Restart or refresh your MCP client.
claude_desktop_config.json
{
"mcpServers": {
"Neon": {
"type": "http",
"url": "https://mcp.neon.tech/mcp"
}
}
}
Fit and risk
Not for
- Production environments requiring fine-grained control.
- Users needing a full SQL interface and complex transaction handling.
- Users who want to run fully offline or without depending on remote services.
Required permissions
- Neon account and authentication (OAuth or API key).
- Access, create, modify, and delete Neon projects, branches, databases, and resources.
- Execute SQL queries (read/write).
- Manage authentication and Data API configurations.
- Read logs and documentation index.
Risks and side effects
- Natural language requests may accidentally execute destructive operations (e.g., deleting projects or branches).
- Unauthorized individuals may access your account via API key or OAuth.
- Production use carries risk of accidental changes; official recommendation is for local development only.
- Careful review of LLM-proposed actions is required.
Troubleshooting
- Connection failures: Check network proxy/firewall and ensure client supports streamable-http.
- Authentication errors: Re-authorize OAuth or verify API key validity.
- Tools unavailable: Check if read-only mode or tool category restrictions are enabled.
- Project access: Confirm project belongs to personal account or provide organization ID.
- IP allowlist: If IP Allow is enabled, add IPs `34.192.103.46` and `23.22.233.166` to allowlist.
Use cases
Create and manage Neon projects and branches using natural language.
Execute SQL queries and transactions through conversation.
Run database migrations without writing SQL manually.
Analyze query performance and optimize slow queries.
Configure Neon Auth and Data API.
Supported clients
Claude DesktopFull support
CursorFull support
VS CodeFull support
Claude CodeFull support
KiroFull support