All servers / Database / PostgreSQL MCP server
PostgreSQL MCP server
A Model Context Protocol (MCP) server that provides comprehensive PostgreSQL database management capabilities for AI assistants
Tested by ConnectATDScore 77 out of 100. Tested 2026-11-18 on package version 1.0.7. Package: @henkey/postgres-mcp-server · source
Score breakdown
| Runs | 18 / 20 | |
|---|---|---|
| Tool descriptions | 17 / 20 | |
| Package safety | 12 / 20 | |
| Maintenance | 14 / 20 | |
| Adoption | 16 / 20 |
What we saw
- Starts and answers the MCP handshake: yes (3.9 seconds including download)
- Tools offered: 18
- Last published: 2026-06-23
- Weekly downloads (npm): 10,757
- License: AGPL-3.0 · Direct dependencies: 7
Notes
- The package runs install scripts, which execute code when you install it.
Want this server set up for your team?
ConnectATD builds AI automation and wires up MCP servers like this one. Tell us what you are trying to do.
Talk to ConnectATDTools and how they are described
Agents choose tools from these descriptions. Under each name you can see how many of its parameters are explained.
pg_analyze_database2 of 2 parameters describedAnalyze PostgreSQL database configuration and performance
pg_debug_database0 of 3 parameters describedDebug common PostgreSQL issues
pg_manage_schema9 of 9 parameters describedManage PostgreSQL schema - get schema info, create/alter tables, manage enums. Examples: operation="get_info" for table lists, operation="create_table" with tableName and columns, operation="get_enums" to list enums, operation="create_enum" with enumName and values
pg_manage_functions13 of 13 parameters describedManage PostgreSQL functions - get, create, or drop functions with a single tool. Examples: operation="get" to list functions, operation="create" with functionName="test_func", parameters="" (empty for no params), returnType="TEXT", functionBody="SELECT 'Hello'"
pg_manage_triggers14 of 14 parameters describedManage PostgreSQL triggers - get, create, drop, and enable/disable triggers. Examples: operation="get" to list triggers, operation="create" with triggerName, tableName, functionName, operation="drop" with triggerName and tableName, operation="set_state" with triggerName, tableName, enable
pg_manage_indexes19 of 19 parameters describedManage PostgreSQL indexes - get, create, drop, reindex, and analyze usage with a single tool. Examples: operation="get" to list indexes, operation="create" with indexName, tableName, columns, operation="analyze_usage" for performance analysis
pg_manage_constraints18 of 18 parameters describedManage PostgreSQL constraints - get, create foreign keys, drop foreign keys, create constraints, drop constraints. Examples: operation="get" to list constraints, operation="create_fk" with constraintName, tableName, columnNames, referencedTable, referencedColumns
pg_manage_rls12 of 12 parameters describedManage PostgreSQL Row-Level Security - enable/disable RLS and manage policies. Examples: operation="enable" with tableName="users", operation="create_policy" with tableName, policyName, using, check
pg_manage_users20 of 20 parameters describedManage PostgreSQL users and permissions - create, drop, alter users, grant/revoke permissions. Examples: operation="create" with username="testuser", operation="grant" with username, permissions, target, targetType
pg_manage_query14 of 15 parameters describedManage PostgreSQL query analysis and performance - operation="explain" for EXPLAIN plans, operation="get_slow_queries" for slow query analysis, operation="get_stats" for query statistics, operation="reset_stats" for clearing statistics
pg_execute_query6 of 6 parameters describedExecute SELECT queries and data retrieval operations - operation="select/count/exists" with query and optional parameters. Examples: operation="select", query="SELECT * FROM users WHERE created_at > $1", parameters=["2024-01-01"]
pg_execute_mutation8 of 8 parameters describedExecute data modification operations (INSERT/UPDATE/DELETE/UPSERT) - operation="insert/update/delete/upsert" with table and data. Examples: operation="insert", table="users", data={"name":"John","email":"john@example.com"}
pg_execute_sql6 of 6 parameters describedExecute arbitrary SQL statements - sql="ANY_VALID_SQL" with optional parameters and transaction support. Examples: sql="CREATE INDEX ...", sql="WITH complex_cte AS (...) SELECT ...", transactional=true
pg_manage_comments9 of 9 parameters describedManage PostgreSQL object comments - get, set, remove comments on tables, columns, functions, and other database objects. Examples: operation="get" with objectType="table", objectName="users", operation="set" with comment text, operation="bulk_get" for discovery
pg_export_table_data1 of 6 parameters describedExport table data to JSON or CSV format
pg_import_table_data1 of 6 parameters describedImport data from JSON or CSV file into a table
pg_copy_between_databases0 of 5 parameters describedCopy data between two databases
pg_monitor_database1 of 6 parameters describedGet real-time monitoring information for a PostgreSQL database
Tested in a sandbox with an empty environment: no API keys, a throwaway folder, nothing from a real account. A passing test shows the server runs and responds. It is not a security audit.