- Category: databases
- Auth: DCR_OAUTH
- Composio-managed OAuth available? No
- Tools: 104
- Triggers: 0
- Slug:
NEON_MCP - Version: 20261018_00
Tools
Add auth oauth provider
Add auth oauth provider
Add auth trusted domain
Add auth trusted domain
Compare database schema
Compare database schema
NEON_MCP_COMPARE_DATABASE_SCHEMACompare one database’s SQL schema on a branch to another. database_name is required. Omit base_branch_id to compare against the parent; it is a branch id (br-...), not a name. Pass lsn, timestamp, base_lsn, or base_timestamp only for a point-in-time comparison.branch_id is a branch id (br-…), not a branch name. Call list_branches to resolve a name.Input Parameters
Complete database migration
Complete database migration
NEON_MCP_COMPLETE_DATABASE_MIGRATIONApply or discard a prepared migration and delete the temporary branch. NEVER run autonomously; always ask the user first. Pass migration_id, migration_sql, database_name, project_id, temporary_branch_id, and parent_branch_id from prepare_database_migration. Set apply_changes false to discard; omitting it applies the migration.Input Parameters
Complete query tuning
Complete query tuning
NEON_MCP_COMPLETE_QUERY_TUNINGApply or discard query-tuning changes and delete the temporary branch. NEVER run autonomously. Before calling, apply suggested SQL with run_sql on the temporary branch and re-run explain_sql_statement. Pass the tuning_id from prepare_query_tuning, not the branch id, plus temporary_branch_id. Set apply_changes true to apply; omitting it discards. Call this even when the user rejects the changes. Do not use prepare_database_migration.Input Parameters
Create auth user
Create auth user
Create branch
Create branch
NEON_MCP_CREATE_BRANCHCreates a branch with a read-write compute and waits until it is ready. Pass no_compute: true to skip the endpoint. Does not return a connection string; call get_connection_string with the project and branch id. Copies the parent at HEAD; point-in-time restore is restore_snapshot.Input Parameters
Create postgres database
Create postgres database
Create postgres endpoint
Create postgres endpoint
Create postgres role
Create postgres role
Create project
Create project
Create snapshot
Create snapshot
Create storage bucket
Create storage bucket
Delete auth oauth provider
Delete auth oauth provider
Delete auth trusted domain
Delete auth trusted domain
Delete auth user
Delete auth user
Delete branch
Delete branch
Delete data api
Delete data api
Delete function
Delete function
Delete functions custom domain
Delete functions custom domain
Delete postgres database
Delete postgres database
Delete postgres endpoint
Delete postgres endpoint
Delete postgres role
Delete postgres role
Delete project
Delete project
Delete snapshot
Delete snapshot
Delete storage bucket
Delete storage bucket
Delete storage object
Delete storage object
Delete storage objects by prefix
Delete storage objects by prefix
Deploy function
Deploy function
NEON_MCP_DEPLOY_FUNCTIONCreates a deployment for the function. Supply at least one of zip, environment, or runtime; omitted fields inherit the latest version. The first deployment must include zip.branch_id is a branch id (br-…), not a branch name. Call list_branches to resolve a name.Input Parameters
Describe branch
Describe branch
Describe project
Describe project
Describe table schema
Describe table schema
NEON_MCP_DESCRIBE_TABLE_SCHEMAGet column definitions, data types, and constraints for a specific table. Do not use when you need all tables in a database (use get_database_tables instead).Input Parameters
Disable auth
Disable auth
Explain sql statement
Explain sql statement
NEON_MCP_EXPLAIN_SQL_STATEMENTAnalyze the query execution plan for a SQL statement using EXPLAIN ANALYZE. Do not use when you need to execute the query for results (use run_sql instead).Input Parameters
Fetch
Fetch
Finalize branch restore
Finalize branch restore
NEON_MCP_FINALIZE_BRANCH_RESTOREFinalize a branch created with restore_snapshot and finalize: false: reassign computes (this restarts them) and swap names so it replaces the original branch.branch_id is a branch id (br-…), not a branch name. Call list_branches to resolve a name.Input Parameters
Get ai gateway
Get ai gateway
Get auth
Get auth
Get branch
Get branch
Get connection string
Get connection string
NEON_MCP_GET_CONNECTION_STRINGGet a PostgreSQL connection string for a Neon database. The branch must have a compute endpoint. create_project and create_branch do not return one; call this after they succeed. All parameters are optional; the tool resolves the project, branch, and database automatically if not specified. Requires write access: the connection string carries a privileged role password, so it is unavailable in read-only mode. A read-only caller who needs a DATABASE_URL must copy it from https://console.neon.tech manually.Input Parameters
Get data api
Get data api
Get database tables
Get database tables
Get default branch
Get default branch
Get doc resource
Get doc resource
Get function
Get function
Get neon auth config
Get neon auth config
Get operation
Get operation
Get postgres database
Get postgres database
Get postgres endpoint
Get postgres endpoint
Get postgres role
Get postgres role
Get snapshot schedule
Get snapshot schedule
Get storage
Get storage
Inspect database
Inspect database
NEON_MCP_INSPECT_DATABASERun one read-only neon inspect db check (pick check from the input schema). Not for arbitrary SQL (run_sql), one statement’s plan (explain_sql_statement), or applying indexes (prepare_query_tuning). Omit database_name to cover every database; some checks are compute-wide. If a check needs an extension, the tool names CREATE EXTENSION; ask before running it.Input Parameters
table-sizes: Size of each table (including TOAST), largest first (pg_table_size) index-sizes: Size of each index, largest first (pg_relation_size) unused-indexes: Non-unique indexes with fewer than 50 scans — candidates for removal (pg_stat_user_indexes) seq-scans: Number of sequential scans recorded against each table (pg_stat_user_tables) long-running-queries: Queries running longer than 5 minutes (pg_stat_activity) stalled-queries: Active queries running longer than 30 seconds with parallel-worker grouping, waits, and blockers, oldest query group first (compute-wide) locks: Locks held with the acquiring query and its age (pg_locks + pg_stat_activity) outliers: The 25 queries with the highest cumulative execution time since statistics were last reset (needs pg_stat_statements) calls: The 25 most frequently executed queries since statistics were last reset (needs pg_stat_statements) lfc-hit-rate: Local File Cache hit rate (compute-wide, needs neon extension) working-set: Estimated working set vs LFC size (compute-wide, needs neon extension) vacuum-stats: Autovacuum status per table: last (auto)vacuum, dead tuples, threshold bloat: Estimated bloat for the 25 most bloated tables (statistical estimate, no extension needed) replication-slots: Replication slots (compute-wide): kind, status, client, restart/confirmed-flush LSNs, and lag (pg_replication_slots + pg_stat_replication) subscriptions: Per-table logical replication progress on this subscriber (pg_subscription_rel)truncated is true. A few checks are capped in SQL and say so in their description.databaseName. The response limit applies to the combined rows after that.List auth oauth providers
List auth oauth providers
List auth trusted domains
List auth trusted domains
List branch computes
List branch computes
List branches
List branches
List docs resources
List docs resources
NEON_MCP_LIST_DOCS_RESOURCESList Neon documentation page slugs from neon.com/docs/llms.txt. Call this before get_doc_resource; do not guess slugs.List functions
List functions
List functions custom domains
List functions custom domains
List log fields
List log fields
List log field values
List log field values
NEON_MCP_LIST_LOG_FIELD_VALUESLists distinct values for a low-cardinality log field. Call list_log_fields first for field_name; a field the branch has never emitted returns unknown_field. Pass since or start_time, not both; default is the previous six hours, max seven days. Private beta.branch_id is a branch id (br-…), not a branch name. Call list_branches to resolve a name.Input Parameters
List operations
List operations
List organizations
List organizations
List postgres databases
List postgres databases
List postgres endpoints
List postgres endpoints
List postgres roles
List postgres roles
List project members
List project members
List project permissions
List project permissions
List projects
List projects
List regions
List regions
NEON_MCP_LIST_REGIONSLists Neon regions available to the authenticated account.List slow queries
List slow queries
NEON_MCP_LIST_SLOW_QUERIESList queries from pg_stat_statements by execution time, slowest first. For sizes, indexes, locks, cache, bloat, or replication use inspect_database.Input Parameters
List snapshots
List snapshots
List storage buckets
List storage buckets
List storage objects
List storage objects
NEON_MCP_LIST_STORAGE_OBJECTSLists objects visible in the named bucket on the specified branch, including those inherited from ancestor branches. Returns every page. Pass limit to cap how many.branch_id is a branch id (br-…), not a branch name. Call list_branches to resolve a name.Input Parameters
Prepare database migration
Prepare database migration
NEON_MCP_PREPARE_DATABASE_MIGRATIONApply a schema change on a temporary branch and return a migration_id. Test with run_sql on that branch, ask the user, then complete_database_migration — even if they reject, so the temporary branch is deleted. Pass every field from the prepare response.Input Parameters
Prepare query tuning
Prepare query tuning
NEON_MCP_PREPARE_QUERY_TUNINGAnalyze a slow query on a temporary branch and return a tuning_id. Apply suggested SQL with run_sql on that branch, re-run explain_sql_statement there, then complete_query_tuning with the tuning_id (not the branch id) — apply_changes true if they accept, omit it or pass false if they reject, so the temporary branch is deleted. Do not use prepare_database_migration.Input Parameters
Presign storage object
Presign storage object
NEON_MCP_PRESIGN_STORAGE_OBJECTReturns a presigned URL that transfers bytes directly to or from the object’s bucket on the specified branch, without the caller ever handling S3 credentials.branch_id is a branch id (br-…), not a branch name. Call list_branches to resolve a name.Input Parameters
Provision neon auth
Provision neon auth
Provision neon data api
Provision neon data api
Query logs
Query logs
NEON_MCP_QUERY_LOGSReturns logs for a branch. Pass limit to cap how many. There is no cursor argument. Filters combine with AND. Pass logql instead of structured filters, not with them. Give the window as since or start_time, not both; default is the previous hour, max seven days; end_time is exclusive. Private beta; a branch without logs access returns HTTP 404 with reason “telemetry_not_enabled”.branch_id is a branch id (br-…), not a branch name. Call list_branches to resolve a name.Input Parameters
Recover project
Recover project
Register functions custom domain
Register functions custom domain
NEON_MCP_REGISTER_FUNCTIONS_CUSTOM_DOMAINRegisters a hostname on the branch and routes it to a function. Pass entity_type: "function" and entity_id as the slug from list_functions. Point a CNAME at the returned cname_target.branch_id is a branch id (br-…), not a branch name. Call list_branches to resolve a name.Input Parameters
Reset from parent
Reset from parent
NEON_MCP_RESET_FROM_PARENTReset a branch to its parent’s current HEAD. Discards every change the branch has written since it diverged. NEVER run autonomously; always ask the user first. preserve_under_name saves the current state first and is required when the branch has children; those children move to the new branch. Point-in-time restore is restore_snapshot.branch_id is a branch id (br-…), not a branch name. Call list_branches to resolve a name.Input Parameters
Reset postgres role password
Reset postgres role password
Restart postgres endpoint
Restart postgres endpoint
Restore snapshot
Restore snapshot
NEON_MCP_RESTORE_SNAPSHOTRestore a snapshot onto a new or existing branch. The call waits until the branch is ready. Pass target_branch_id to restore onto an existing branch; omit it to create one. Pass finalize: false then call finalize_branch_restore to swap names later.Input Parameters
Run sql
Run sql
NEON_MCP_RUN_SQLExecute one SQL statement on a Neon database. If a prior step created a temporary branch, pass that branch_id. NEVER run destructive SQL autonomously; always ask the user first.Input Parameters
Run sql transaction
Run sql transaction
NEON_MCP_RUN_SQL_TRANSACTIONExecute multiple SQL statements as one transaction. If a prior step created a temporary branch, pass that branch_id. NEVER run destructive SQL autonomously; always ask the user first.Input Parameters
Search
Search
Set default branch
Set default branch
Set snapshot schedule
Set snapshot schedule
Start postgres endpoint
Start postgres endpoint
Suspend postgres endpoint
Suspend postgres endpoint
Update auth config
Update auth config
Update auth oauth provider
Update auth oauth provider
Update auth user role
Update auth user role
Update branch
Update branch
Update data api
Update data api
Update function
Update function
Update postgres database
Update postgres database
Update postgres endpoint
Update postgres endpoint
Update project
Update project