Schema | warehouse-mcp-server

warehouse-mcp-server

Describes the environment variables required to run the server.

Name	Required	Description	Default
`DATABASE_URL`	Yes	Required; point it at a read-only role.
`MAX_ROW_LIMIT`	No	Hard ceiling the caller cannot raise.	5000
`EXPOSED_SCHEMAS`	No	Comma-separated list of schemas to expose.	mart
`DEFAULT_ROW_LIMIT`	No	Default row limit for queries.	200
`STATEMENT_TIMEOUT_MS`	No	Statement timeout in milliseconds.	15000

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
list_tablesA	List every table, view and materialized view available in the mart schema(s), with its description. Call this first — it is cheap and tells you what exists.
describe_tableA	Show the columns, types, nullability and column comments for one table or view. Call this before writing a query against a relation you have not queried before.
run_queryA	Run a read-only SQL SELECT against the warehouse and return rows as JSON. Only SELECT (and WITH ... SELECT) is permitted; a single statement per call. Results are capped at 200 rows by default and 5000 at most — aggregate in SQL rather than pulling rows and counting them yourself.

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/fabianguiliani/warehouse-mcp-server'

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