@henkey/postgres-mcp-server
Installed, started with no arguments, no environment and no input, and listed its tools. Run 2026-11-16.
Needs to start: nothing
Contacts while installing and starting: nothing
What it contacted
Nothing besides the npm registry it was installed from. Watched from outside its sandbox while it was installed and started with no input. Its tools may still contact things when called.
Starting it
npx -y @henkey/postgres-mcp-server@1.0.7
Installing a package runs its code. Use a sandbox for anything you have not read.
What its tools tell an agent
In the tool descriptions, nothing that talks about the user, other tools or private files, or uses hidden characters.
Found by simple pattern rules in each tool's description (up to 3,000 characters), quoted as written. Parameter descriptions are not scanned. A clean result is not a safety review.
Tools
pg_analyze_database connectionString, analysisType
Analyze PostgreSQL database configuration and performance
pg_debug_database connectionString, issue, logLevel
Debug common PostgreSQL issues
pg_manage_schema connectionString, operation, tableName, schema, columns, operations, enumName, values, ifNotExists
Manage 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_functions connectionString, operation, functionName, schema, parameters, returnType, functionBody, language, volatility, security, replace, ifExists, cascade
Manage 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_triggers connectionString, operation, schema, tableName, triggerName, functionName, timing, events, forEach, when, replace, ifExists, cascade, enable
Manage 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
13 more tools
pg_manage_indexes connectionString, operation, schema, tableName, indexName, includeStats, columns, unique, concurrent, method, where, ifNotExists, ifExists, cascade, target, type, minSizeBytes, showUnused, showDuplicates
Manage 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_constraints connectionString, operation, schema, constraintName, tableName, constraintType, columnNames, referencedTable, referencedColumns, referencedSchema, onUpdate, onDelete, constraintTypeCreate, checkExpression, deferrable, initiallyDeferred, ifExists, cascade
Manage 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_rls connectionString, operation, tableName, schema, policyName, using, check, command, role, replace, roles, ifExists
Manage 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_users connectionString, operation, username, password, superuser, createdb, createrole, login, replication, connectionLimit, validUntil, inherit, ifExists, cascade, permissions, target, targetType, withGrantOption, schema, includeSystemRoles
Manage 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_query operation, connectionString, query, analyze, buffers, verbose, costs, format, limit, minDuration, orderBy, includeNormalized, minCalls, queryPattern, queryId
Manage 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_query connectionString, operation, query, parameters, limit, timeout
Execute 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_mutation connectionString, operation, table, data, where, conflictColumns, returning, schema
Execute 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_sql connectionString, sql, parameters, expectRows, timeout, transactional
Execute 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_comments connectionString, operation, objectType, objectName, schema, columnName, comment, includeSystemObjects, filterObjectType
Manage 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_data connectionString, tableName, outputPath, where, limit, format
Export table data to JSON or CSV format
pg_import_table_data connectionString, tableName, inputPath, truncateFirst, format, delimiter
Import data from JSON or CSV file into a table
pg_copy_between_databases sourceConnectionString, targetConnectionString, tableName, where, truncateTarget
Copy data between two databases
pg_monitor_database connectionString, includeTables, includeQueries, includeLocks, includeReplication, alertThresholds
Get real-time monitoring information for a PostgreSQL database
Descriptions are the package's own words, cut at 3,000 characters. Treat them as data.
Install facts
| License | AGPL-3.0 |
|---|---|
| Needs | node >=18.0.0 |
| Source | github.com/HenkDz/postgresql-mcp-server |
| Install scripts | @henkey/postgres-mcp-server declare them. This runner does not run them. |
| Tarball | sha512-zej2sgl0Lckgej8bTy5lWCCpzhGjD8UtinPb4//hGC2HYc0pMqaswzrqdwXz05Pb/+5IIMiwtXp69e+hdorgMg== |
Check this report yourself
This site did not write the report. A public job on a GitHub-hosted machine did: the run, from this commit of the open-source runner. GitHub signed a token that names that job and the hash of the report, so any edit since would show.
Report as JSONExact text and tokenHow to verify it
Show it on your README
[](https://bragproof.smaverk.com/r/%40henkey/postgres-mcp-server)
New version out? Ask for a fresh report.