MCP server for interacting with Neon Management API and databases
Neon MCP server demonstrates solid tool coverage with 20 well-structured database and project management tools. All tools have descriptions (avg 85 chars) and input schemas with typed parameters. Naming follows verb_noun convention consistently (list_, create_, delete_, describe_, run_, get_, prepare_, complete_). However, descriptions are terse (many under 100 chars) and lack context about when to use each tool vs. alternatives. Parameter descriptions are present but minimal. Output schemas are not documented in the source. Error handling guidance is absent. No tool annotations (readOnlyHint/destructiveHint) despite clear risk stratification. Composition is strong, tools chain well (e.g., prepare_database_migration → complete_database_migration). Parameter naming is consistent and mostly unambiguous.
Complete a schema migration by applying changes to the main branch
Complete query tuning by applying suggested changes to improve performance
Create a new branch in a Neon project
Create a new project in your Neon account
Delete a branch from a Neon project
Delete a project from your Neon account
Get detailed information about a branch
Get detailed information about a project including branches and configuration
No output schemas documented. Tool descriptions state what they do but not what fields/structure they return. LLMs cannot plan downstream tool calls or extract required data without knowing response structure.
No tool annotations (readOnlyHint, destructiveHint, idempotentHint) despite clear risk stratification. Tools marked READ_ONLY, WRITE, and DESTRUCTIVE in metadata but not exposed to LLM via schema annotations.
Descriptions lack context about when to use each tool vs. alternatives. E.g., run_sql vs. run_sql_transaction, prepare_database_migration vs. run_sql. LLMs cannot disambiguate without explicit guidance.
Inferred effective spec: <=2025-11-25.
| Scored | Grade | Overall | Spec posture | Rubric |
|---|---|---|---|---|
| 2026-09-23 | D | 56 | <=2025-11-25 | v2 |
Get detailed schema information for a specific table
Analyze a SQL statement using EXPLAIN to understand query execution
Get a connection string for connecting to a Neon database
List all tables in a database
List all compute endpoints for branches in a project
List all projects in your Neon account
List slow queries from a database
Prepare a schema migration by creating a test branch and applying migration SQL
Prepare query tuning by analyzing a SQL statement and creating a test branch
Provision Neon Auth for a project
Execute a SQL query against a Neon database
Execute multiple SQL statements as a transaction
No error handling guidance. Tools do not document what errors are retryable, user-fixable, or fatal. No recovery suggestions (e.g., 'If project not found, call list_projects first').
Parameter descriptions are minimal (avg 50 chars). Many lack format/constraint details. E.g., 'limit' param has default=10 but no min/max bounds stated in description; 'sql' param has no guidance on statement complexity or timeout behavior.