warehouse-mcp
by kalehdoo
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| PG_HOST | No | Postgres host (also used for Redshift) | |
| PG_USER | No | Postgres user | |
| DUCKDB_PATH | No | DuckDB file path or :memory: or md:database | |
| ORACLE_USER | No | Oracle user | |
| PG_DATABASE | No | Postgres database | |
| PG_PASSWORD | No | Postgres password | |
| MCP_API_KEYS | Yes | API keys with roles, format key:role[:set_role=...][:semantic=on|off] | |
| SEMANTIC_DIR | No | Directory containing semantic metadata YAML files | |
| REDSHIFT_HOST | No | Redshift host (alternative to PG_HOST) | |
| REDSHIFT_USER | No | Redshift user | |
| SNOWFLAKE_USER | No | Snowflake user | |
| WAREHOUSE_TYPE | Yes | ||
| MCP_SERVER_PORT | No | Port for the MCP server | 3001 |
| ORACLE_PASSWORD | No | Oracle password | |
| BIGQUERY_PROJECT | No | GCP project ID | |
| MOTHERDUCK_TOKEN | No | MotherDuck access token (required if DUCKDB_PATH starts with md:) | |
| SEMANTIC_DEFAULT | No | Default semantic layer visibility (on/off) | on |
| REDSHIFT_DATABASE | No | Redshift database | |
| REDSHIFT_PASSWORD | No | Redshift password | |
| SNOWFLAKE_ACCOUNT | No | Snowflake account identifier | |
| GUARDRAIL_PII_MASK | No | Enable PII masking (on/off) | off |
| SNOWFLAKE_DATABASE | No | Snowflake database | |
| SNOWFLAKE_WAREHOUSE | No | Snowflake warehouse | |
| ORACLE_CONNECT_STRING | No | Oracle connect string (host:port/service) | |
| SNOWFLAKE_PRIVATE_KEY_PATH | No | Path to Snowflake private key file | |
| OTEL_EXPORTER_OTLP_ENDPOINT | No | OpenTelemetry OTLP HTTP endpoint | |
| GOOGLE_APPLICATION_CREDENTIALS | No | Path to GCP service account JSON key |
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
No tools | |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Latest Blog Posts
- Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)By Om-Shree-0709 on .mcpAgent IdentityOAuth 2.1
- Your AI Chatbot Just Exposed Your CEO's Salary to an InternBy Om-Shree-0709 on .Agent IdentityMCP SecurityOAuth Delegation
- Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)By Om-Shree-0709 on .Agentic AiPrompt InjectionWebAssembly
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/kalehdoo/warehouse-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server