Schema | mcp-postgres-query

mcp-postgres-query

Describes the environment variables required to run the server.

Name	Required	Description	Default
`DATABASE_URL`	Yes	PostgreSQL connection string, e.g., postgresql://user:password@localhost:5432/mydb

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.

Features and capabilities supported by this server

Protocol revision2025-11-25

Capability	Details
`tools`	{}

Functions exposed to the LLM to take actions

Name	Description
queryB	Execute a SQL query against the PostgreSQL database. Supports parameterized queries for safety. Returns rows and row count.
list_tablesA	List all tables in the public schema of the connected database. Returns table names, types (BASE TABLE or VIEW), and the schema they belong to.
describe_tableA	Get detailed column information for a table: column name, data type, nullable, default value, character max length, and ordinal position.
list_indexesA	List all indexes on a given table, including index name, whether it is unique, and the index definition.
explain_queryA	Get the EXPLAIN ANALYZE execution plan for a SQL query. The query runs inside a transaction that is always rolled back, so it never modifies data.
get_table_statsA	Get statistics for a table: estimated row count (from pg_stat), live/dead tuples, last vacuum/analyze times, and total disk size.
get_db_infoA	Get an overview of the connected database: PostgreSQL version, database name, total size on disk, number of tables, and current connection info (user, host, port).

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/lordbasilaiassistant-sudo/mcp-postgres-query'

If you have feedback or need assistance with the MCP directory API, please join our Discord server