# ig-ViraL/pg-mcp-server

Source: https://glimind.com/server/github%2Fig-viral%2Fpg-mcp-server
Registry id: `github/ig-viral/pg-mcp-server`
Status: unknown

## Tools (10)

- `annotate_column`: Write a business-context comment onto a PostgreSQL column.
- `annotate_table`: Write a business-context comment onto a PostgreSQL table.
- `describe_table`: Deep metadata for a single table with columns, PKs, FKs, indexes, sample rows, and row count.
- `explain_query`: Get the execution plan for a query.
- `get_db_health`: Get index bloat, long-running queries, and connection usage.
- `get_row_count`: Get the exact row count for a table.
- `get_slow_queries`: Get slowest statements from pg_stat_statements.
- `list_tables`: List all tables with columns, types, PKs, FKs, indexes, and comments.
- `run_query`: Run a read-only SELECT query against the PostgreSQL database.
- `search_schema`: Full-text search across table names, column names, and column comments.

Measured by Glimind (https://glimind.com): MCP handshake + tool list only, no tool is ever called. CC BY 4.0.