PostgreSQL MCP Server

Analyze PostgreSQL database configuration and performance

Puo’ usare: connectionString analysisType

{
  "tool": "pg_analyze_database",
  "parameters": {
    "connectionString": "<string>",
    "analysisType": "<string>"
  }
}

Debug common PostgreSQL issues

Gli serve: issuestring

Puo’ usare: connectionString logLevel

{
  "tool": "pg_debug_database",
  "parameters": {
    "issue": "<string>"
  }
}

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

Gli serve: operationstring

Puo’ usare: connectionString tableName schema columns operations enumName values ifNotExists

{
  "tool": "pg_manage_schema",
  "parameters": {
    "operation": "<string>"
  }
}

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'"

Gli serve: operationstring

Puo’ usare: connectionString functionName schema parameters returnType functionBody language volatility security replace +2

{
  "tool": "pg_manage_functions",
  "parameters": {
    "operation": "<string>"
  }
}

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

Gli serve: operationstring

Puo’ usare: connectionString schema tableName triggerName functionName timing events forEach when replace +3

{
  "tool": "pg_manage_triggers",
  "parameters": {
    "operation": "<string>"
  }
}

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

Gli serve: operationstring

Puo’ usare: connectionString schema tableName indexName includeStats columns unique concurrent method where +8

{
  "tool": "pg_manage_indexes",
  "parameters": {
    "operation": "<string>"
  }
}

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

Gli serve: operationstring

Puo’ usare: connectionString schema constraintName tableName constraintType columnNames referencedTable referencedColumns referencedSchema onUpdate +7

{
  "tool": "pg_manage_constraints",
  "parameters": {
    "operation": "<string>"
  }
}

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

Gli serve: operationstring

Puo’ usare: connectionString tableName schema policyName using check command role replace roles +1

{
  "tool": "pg_manage_rls",
  "parameters": {
    "operation": "<string>"
  }
}

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

Gli serve: operationstring

Puo’ usare: connectionString username password superuser createdb createrole login replication connectionLimit validUntil +9

{
  "tool": "pg_manage_users",
  "parameters": {
    "operation": "<string>"
  }
}

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

Gli serve: operationstring

Puo’ usare: connectionString query analyze buffers verbose costs format limit minDuration orderBy +4

{
  "tool": "pg_manage_query",
  "parameters": {
    "operation": "<string>"
  }
}

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"]

Gli serve: operationstring querystring

Puo’ usare: connectionString parameters limit timeout

{
  "tool": "pg_execute_query",
  "parameters": {
    "operation": "<string>",
    "query": "<string>"
  }
}

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"}

Gli serve: operationstring tablestring

Puo’ usare: connectionString data where conflictColumns returning schema

{
  "tool": "pg_execute_mutation",
  "parameters": {
    "operation": "<string>",
    "table": "<string>"
  }
}

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

Gli serve: sqlstring

Puo’ usare: connectionString parameters expectRows timeout transactional

{
  "tool": "pg_execute_sql",
  "parameters": {
    "sql": "<string>"
  }
}

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

Gli serve: operationstring

Puo’ usare: connectionString objectType objectName schema columnName comment includeSystemObjects filterObjectType

{
  "tool": "pg_manage_comments",
  "parameters": {
    "operation": "<string>"
  }
}

Export table data to JSON or CSV format

Gli serve: tableNamestring outputPathstring

Puo’ usare: connectionString where limit format

{
  "tool": "pg_export_table_data",
  "parameters": {
    "tableName": "<string>",
    "outputPath": "<string>"
  }
}

Import data from JSON or CSV file into a table

Gli serve: tableNamestring inputPathstring

Puo’ usare: connectionString truncateFirst format delimiter

{
  "tool": "pg_import_table_data",
  "parameters": {
    "tableName": "<string>",
    "inputPath": "<string>"
  }
}

Copy data between two databases

Gli serve: sourceConnectionStringstring targetConnectionStringstring tableNamestring

Puo’ usare: where truncateTarget

{
  "tool": "pg_copy_between_databases",
  "parameters": {
    "sourceConnectionString": "<string>",
    "targetConnectionString": "<string>",
    "tableName": "<string>"
  }
}

Get real-time monitoring information for a PostgreSQL database

Puo’ usare: connectionString includeTables includeQueries includeLocks includeReplication alertThresholds

{
  "tool": "pg_monitor_database",
  "parameters": {
    "connectionString": "<string>",
    "includeTables": "<boolean>",
    "includeQueries": "<boolean>"
  }
}