{"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\":[]}}","token":"eyJhbGciOiJSUzI1NiIsImtpZCI6IjM4ODI2YjE3LTZhMzAtNWY5Yi1iMTY5LThiZWI4MjAyZjcyMyIsInR5cCI6IkpXVCIsIng1dCI6InlrTmFZNHFNX3RhNGsyVGdaT0NFWUxrY1lsQSJ9.eyJhY3RvciI6Iml0c0hhZGRhZCIsImFjdG9yX2lkIjoiMTE0NzMyNjEiLCJhdWQiOiJicmFncHJvb2YtcmVwb3J0OmY5NmFjMzA1YWQwNDMyODA4ZjVhZjA3YjVmOGExNGI0NjhjYTJiMzYzMTkzOTVhYWE0YmI4NmRiMGVjN2QzYWMiLCJiYXNlX3JlZiI6IiIsImNoZWNrX3J1bl9pZCI6IjEzMzI2Mzk5NTM2MyIsImV2ZW50X25hbWUiOiJzY2hlZHVsZSIsImV4cCI6MTc5NDgyODg4NiwiaGVhZF9yZWYiOiIiLCJpYXQiOjE3OTQ4Mjg1ODYsImlzcyI6Imh0dHBzOi8vdG9rZW4uYWN0aW9ucy5naXRodWJ1c2VyY29udGVudC5jb20iLCJqb2Jfd29ya2Zsb3dfcmVmIjoiaXRzSGFkZGFkL2JyYWdwcm9vZi8uZ2l0aHViL3dvcmtmbG93cy9yZXBvcnQueW1sQHJlZnMvaGVhZHMvbWFpbiIsImpvYl93b3JrZmxvd19zaGEiOiJlYWFmZmZmYWY1MjI1NWQxYjc3ZGM0YWFjZmZkZmFmMzUzZjBjMTJjIiwianRpIjoiZTIyMzE0ZDAtODJhYS00OTA1LWFkODktODU0ZjA0ZTZmNTMxIiwibmJmIjoxNzk0ODI4Mjg2LCJyZWYiOiJyZWZzL2hlYWRzL21haW4iLCJyZWZfcHJvdGVjdGVkIjoiZmFsc2UiLCJyZWZfdHlwZSI6ImJyYW5jaCIsInJlcG9zaXRvcnkiOiJpdHNIYWRkYWQvYnJhZ3Byb29mIiwicmVwb3NpdG9yeV9pZCI6IjE0NTQ2MjExODMiLCJyZXBvc2l0b3J5X293bmVyIjoiaXRzSGFkZGFkIiwicmVwb3NpdG9yeV9vd25lcl9pZCI6IjExNDczMjYxIiwicmVwb3NpdG9yeV92aXNpYmlsaXR5IjoicHVibGljIiwicnVuX2F0dGVtcHQiOiIxIiwicnVuX2lkIjoiNDM4NTcwNzAyMTYiLCJydW5fbnVtYmVyIjoiMjQiLCJydW5uZXJfZW52aXJvbm1lbnQiOiJnaXRodWItaG9zdGVkIiwic2hhIjoiZWFhZmZmZmFmNTIyNTVkMWI3N2RjNGFhY2ZmZGZhZjM1M2YwYzEyYyIsInN1YiI6InJlcG86aXRzSGFkZGFkQDExNDczMjYxL2JyYWdwcm9vZkAxNDU0NjIxMTgzOnJlZjpyZWZzL2hlYWRzL21haW4iLCJ3b3JrZmxvdyI6InJlcG9ydCIsIndvcmtmbG93X3JlZiI6Iml0c0hhZGRhZC9icmFncHJvb2YvLmdpdGh1Yi93b3JrZmxvd3MvcmVwb3J0LnltbEByZWZzL2hlYWRzL21haW4iLCJ3b3JrZmxvd19zaGEiOiJlYWFmZmZmYWY1MjI1NWQxYjc3ZGM0YWFjZmZkZmFmMzUzZjBjMTJjIn0.leU1Xvf0afska12EsrvaP59DqZtBiRp4cR_RdooCc1DG9MdZ--yX-5IYYStvZ24jMF3ZlGz51JyStPGSgVu9O8LlT_nns3U2ZCZ3AINM22-xcrMBd1W70g2J8tcx6vxHIuPTX3QOctqAon9AwQGKAfIM3XpwDaRrN1Gp2iLQmZ3j4eGr7_7qAuJR9VVMs6Mpzj18yAHBytHp8gcBVbj3n7-Q5Tic2JP5dObyYujyiSgKS3q1XFTRa3c0R3M6IKz_tsT5HHBa9KgXlA5xRLsz2IxXXodHytwkMZQ1xq2pwRARmAgvSXjFEgnhPBtrSt7__6ImxZd-T_FtqxuqGkwUuA"}