{"report":{"v":1,"package":"@henkey/postgres-mcp-server","version":"1.0.7","ranAt":"2026-11-16T11:29:37.596Z","install":{"ok":true,"integrity":"sha512-zej2sgl0Lckgej8bTy5lWCCpzhGjD8UtinPb4//hGC2HYc0pMqaswzrqdwXz05Pb/+5IIMiwtXp69e+hdorgMg==","deps":114,"scripts":["@henkey/postgres-mcp-server"],"bins":["postgres-mcp"],"license":"AGPL-3.0","engines":"node >=18.0.0","repository":"git+https://github.com/HenkDz/postgresql-mcp-server.git","bin":"postgres-mcp"},"start":{"ok":true,"ms":188,"serverName":"postgresql-mcp-server","serverVersion":"1.0.7","protocol":"2025-06-18","stderr":"[MCP Info] No tools configuration file provided. All available tools will be enabled.\n[MCP Info] No tools configuration file provided. All available tools will be enabled.\nPostgreSQL MCP server running on stdio\n"},"tools":[{"name":"pg_analyze_database","description":"Analyze PostgreSQL database configuration and performance","params":["connectionString","analysisType"]},{"name":"pg_debug_database","description":"Debug common PostgreSQL issues","params":["connectionString","issue","logLevel"]},{"name":"pg_manage_schema","description":"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","params":["connectionString","operation","tableName","schema","columns","operations","enumName","values","ifNotExists"]},{"name":"pg_manage_functions","description":"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'\"","params":["connectionString","operation","functionName","schema","parameters","returnType","functionBody","language","volatility","security","replace","ifExists","cascade"]},{"name":"pg_manage_triggers","description":"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","params":["connectionString","operation","schema","tableName","triggerName","functionName","timing","events","forEach","when","replace","ifExists","cascade","enable"]},{"name":"pg_manage_indexes","description":"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","params":["connectionString","operation","schema","tableName","indexName","includeStats","columns","unique","concurrent","method","where","ifNotExists","ifExists","cascade","target","type","minSizeBytes","showUnused","showDuplicates"]},{"name":"pg_manage_constraints","description":"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","params":["connectionString","operation","schema","constraintName","tableName","constraintType","columnNames","referencedTable","referencedColumns","referencedSchema","onUpdate","onDelete","constraintTypeCreate","checkExpression","deferrable","initiallyDeferred","ifExists","cascade"]},{"name":"pg_manage_rls","description":"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","params":["connectionString","operation","tableName","schema","policyName","using","check","command","role","replace","roles","ifExists"]},{"name":"pg_manage_users","description":"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","params":["connectionString","operation","username","password","superuser","createdb","createrole","login","replication","connectionLimit","validUntil","inherit","ifExists","cascade","permissions","target","targetType","withGrantOption","schema","includeSystemRoles"]},{"name":"pg_manage_query","description":"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","params":["operation","connectionString","query","analyze","buffers","verbose","costs","format","limit","minDuration","orderBy","includeNormalized","minCalls","queryPattern","queryId"]},{"name":"pg_execute_query","description":"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\"]","params":["connectionString","operation","query","parameters","limit","timeout"]},{"name":"pg_execute_mutation","description":"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\"}","params":["connectionString","operation","table","data","where","conflictColumns","returning","schema"]},{"name":"pg_execute_sql","description":"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","params":["connectionString","sql","parameters","expectRows","timeout","transactional"]},{"name":"pg_manage_comments","description":"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","params":["connectionString","operation","objectType","objectName","schema","columnName","comment","includeSystemObjects","filterObjectType"]},{"name":"pg_export_table_data","description":"Export table data to JSON or CSV format","params":["connectionString","tableName","outputPath","where","limit","format"]},{"name":"pg_import_table_data","description":"Import data from JSON or CSV file into a table","params":["connectionString","tableName","inputPath","truncateFirst","format","delimiter"]},{"name":"pg_copy_between_databases","description":"Copy data between two databases","params":["sourceConnectionString","targetConnectionString","tableName","where","truncateTarget"]},{"name":"pg_monitor_database","description":"Get real-time monitoring information for a PostgreSQL database","params":["connectionString","includeTables","includeQueries","includeLocks","includeReplication","alertThresholds"]}],"toolsHash":"9c96002a3a1eafa5f70c0f4254a9b76b1889b2a68c262b0f1e2dc9ca5c867d3b","wrote":[],"host":{"commit":"eaaffffaf52255d1b77dc4aacffdfaf353f0c12c","run":"https://github.com/itsHaddad/bragproof/actions/runs/43857070216"},"network":{"names":["registry.npmjs.org"],"conns":[]}},"summary":{"outcome":"started","needs":[],"contacts":[],"flags":[],"tools":18,"wrote":0,"callsTried":0,"callsAnswered":0,"callContacts":[]},"history":[{"package":"@henkey/postgres-mcp-server","version":"1.0.7","ranAt":"2026-11-16T11:29:37.596Z","outcome":"started","tools":18,"contacts":0,"flags":0,"serious":0,"toolsHash":"9c96002a3a1eafa5f70c0f4254a9b76b1889b2a68c262b0f1e2dc9ca5c867d3b"}],"page":"https://bragproof.smaverk.com/r/%40henkey/postgres-mcp-server"}