App Data MCP
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DB_HOST | No | PostgreSQL host for audit logging | |
| DB_NAME | No | PostgreSQL database name for audit logging | |
| DB_PORT | No | PostgreSQL port for audit logging (e.g., 5432) | |
| DB_TYPE | No | Database type for audit logging (e.g., postgres) | |
| DB_USER | No | PostgreSQL user for audit logging | |
| DB_SCHEMA | No | PostgreSQL schema for audit logging (default: public) | |
| DB_PASSWORD | No | PostgreSQL password for audit logging | |
| MCP_HTTP_HOST | No | Host to bind HTTP server (default: 0.0.0.0) | |
| MCP_HTTP_PORT | No | Port for HTTP server (default: 3000) | |
| METABASE_PASS | No | Metabase password for service account (alternative to METABASE_API_KEY) | |
| METABASE_USER | No | Metabase username for service account authentication | |
| AUDIT_LOG_TABLE | No | Table name for audit logs (default: app_data_mcp_audit_logs) | |
| POSTHOG_API_KEY | No | Compatibility alias for POSTHOG_PERSONAL_API_KEY (not recommended) | |
| DATA_ASSETS_FILE | No | Path to the local assets JSON file (default: config/assets.json) | |
| METABASE_API_KEY | No | Metabase API key for service account authentication | |
| POSTHOG_BASE_URL | No | Base URL of the PostHog instance | |
| AUDIT_LOG_ENABLED | No | Enable audit logging to database (true/false) | |
| METABASE_BASE_URL | No | Base URL of the Metabase instance | |
| METABASE_PASSWORD | No | Compatibility alias for METABASE_PASS | |
| METABASE_USERNAME | No | Compatibility alias for METABASE_USER | |
| METABASE_AUTH_MODE | No | Metabase authentication mode (e.g., user-session) | |
| METABASE_LOGIN_URL | No | Login URL for user session authentication | |
| POSTHOG_PROJECT_ID | No | PostHog project ID | |
| APP_DATA_SESSION_FILE | No | Path to store Metabase sessions (default: .data/metabase-sessions.json) | |
| DATA_MAX_SEARCH_LIMIT | No | Maximum number of search results (default: 50) | |
| MCP_HTTP_BEARER_TOKEN | No | Shared HTTP bearer token for server protection | |
| DATA_MAX_RESPONSE_BYTES | No | Maximum response size in bytes (default: 1000000) | |
| DATA_MAX_DASHBOARD_CARDS | No | Maximum number of cards to execute when fetching a dashboard | |
| POSTHOG_PERSONAL_API_KEY | No | PostHog Personal API key (recommended) | |
| DATA_DEFAULT_SEARCH_LIMIT | No | Default number of search results returned (default: 10) | |
| DATA_MAX_RESULT_ROW_LIMIT | No | Maximum result rows allowed for run_asset (default: 500) | |
| METABASE_SESSION_TTL_HOURS | No | Time-to-live for stored Metabase sessions in hours (default: 168) | |
| APP_DATA_REQUIRE_AUTH_TOKEN | No | If true, all data tools require a valid user personal token; set to 'true' or 'false' | |
| APP_DATA_MCP_PUBLIC_BASE_URL | No | MCP public base URL for redirect after Metabase login, e.g., http://127.0.0.1:3000 | |
| DATA_DEFAULT_RESULT_ROW_LIMIT | No | Default number of result rows for run_asset (default: 100) | |
| METABASE_ALLOW_SERVICE_FALLBACK | No | Allow fallback to service account if no user session (true/false) |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| search_assetsB | Search local metadata for Metabase dashboards/cards, PostHog insights, metrics, tables, and events. |
| get_assetB | Get full metadata for one data asset, including source URL, query text, columns, children, and warnings. |
| trace_assetB | Trace where a data asset comes from, including upstream tables/events/assets and original platform links. |
| run_assetC | Return read-only live data for a supported Metabase/PostHog asset, with local sampleData fallback. |
| list_domainsB | List business domains found in the local metadata config. |
| catalog_statusA | Show whether the local asset catalog is initialized and how many assets it contains. |
| auth_statusA | Check the current MCP request user and Metabase authorization status. Call this before run_asset for Metabase assets. |
| connector_statusA | Show whether Metabase and PostHog connector environment variables are configured. Secrets are never returned. |
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
- 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/jedshen123/app-data-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server