pg-context
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
| resources | {
"listChanged": true
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_schemasA | List all available database schemas (excluding system schemas like pg_catalog and information_schema) |
| list_tablesA | List all tables and views in a given schema with estimated row counts, sizes, and comments |
| describe_tableB | Get full structural details of a table as CREATE TABLE DDL, including columns, data types, constraints, foreign keys, and indexes |
| list_foreign_keysA | List foreign key relationships between tables to understand data model associations and joins |
| list_indexesA | List indexes on tables with sizes and scan usage statistics to evaluate index health |
| suggest_indexesB | Analyze query patterns, scan ratios, and missing foreign key indexes to provide index recommendations |
| read_queryA | Execute a safe read-only SQL query (SELECT, WITH, SHOW) with strict LIMIT enforcement and formatting |
| explain_queryB | Get query execution plan via PostgreSQL EXPLAIN (or EXPLAIN ANALYZE) to debug performance bottlenecks |
| get_database_infoA | Get high-level PostgreSQL database runtime information: version, size, active connection count, and server settings |
| get_table_statsA | Get scan statistics, tuple counts, dead row accumulation, and maintenance history for tables |
| get_slow_queriesB | Retrieve top slowest queries recorded by pg_stat_statements extension (if enabled in PostgreSQL) |
| list_extensionsA | List installed PostgreSQL extensions with version information and specialized framework detection (PostGIS, TimescaleDB, pgvector) |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
| full-schema | Complete PostgreSQL schema definitions (DDL) for all configured schemas |
| stats-overview | Comprehensive health overview of the PostgreSQL database: sizes, connection counts, dead tuples, and optimization alerts |
TDQS
Scored across 12 tools
Each tool targets a distinct aspect of PostgreSQL database introspection: schemas, tables, relationships, indexes, query execution, performance stats, and extensions. There is no overlap in purpose.
All tools follow a consistent verb_noun pattern in snake_case (e.g., list_schemas, describe_table, read_query), making the API predictable and easy to navigate.
With 12 tools, the server covers the key areas of database analysis without being bloated. Each tool serves a distinct role, and the count is appropriate for the domain.
The set covers schema exploration, table details, indexing, query analysis, performance monitoring, and extension information. No obvious gaps for a read-only database context server.