FastAPI Database MCP Server
by amararun
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| LOG_LEVEL | No | Logging level | INFO |
| RATE_LIMIT | No | Per-IP rate limit (SlowAPI format, e.g. 60/hour, 100/minute) | 30/minute |
| DUCKDB_FILE | No | Path to .duckdb file | ./data/t20_cricket.duckdb |
| PG_POOL_MAX | No | Postgres connection pool maximum size | 6 |
| PG_POOL_MIN | No | Postgres connection pool minimum size | 3 |
| AUTH0_DOMAIN | No | Auth0 tenant domain (enables /mcp-secure when set) | |
| MAX_TSV_ROWS | No | Max rows returned in TSV format | 1000 |
| AUTH_FAIL_MAX | No | Max failed auth attempts per IP before blocking | 5 |
| MAX_JSON_ROWS | No | Max rows returned in JSON format | 1000 |
| AUTH0_AUDIENCE | No | Auth0 API identifier | |
| DUCKDB_THREADS | No | DuckDB thread limit | 2 |
| API_MONITOR_KEY | No | tigzig-api-monitor API key | |
| API_MONITOR_URL | No | tigzig-api-monitor endpoint URL | |
| AUTH0_CLIENT_ID | No | Auth0 application client ID | |
| DUCKDB_TEMP_DIR | No | DuckDB temporary directory | /tmp/duckdb |
| AUTH_FAIL_WINDOW | No | Failed auth tracking window in seconds (default: 24 hours) | 86400 |
| GLOBAL_RATE_LIMIT | No | Global rate limit across all IPs | 200/minute |
| SUPABASE_POSTGRES | Yes | Postgres connection string (use a read-only user) | |
| CORS_ALLOW_ORIGINS | No | Comma-separated allowed origins | * |
| MAX_RESPONSE_BYTES | No | Max response size in bytes (default: 1MB) | 1048576 |
| AUTH0_CLIENT_SECRET | No | Auth0 application client secret | |
| DUCKDB_MEMORY_LIMIT | No | DuckDB memory limit | 512MB |
| RENDER_EXTERNAL_URL | No | Base URL for MCP (auto-detected on Render) | |
| MAX_CONCURRENT_GLOBAL | No | Max simultaneous queries server-wide | 10 |
| MAX_CONCURRENT_PER_IP | No | Max simultaneous queries per IP | 4 |
| DUCKDB_QUERY_TIMEOUT_MS | No | DuckDB query timeout in milliseconds | 15000 |
| PG_POOL_ACQUIRE_TIMEOUT | No | Seconds to wait for a pool connection before returning 503 | 15 |
| PG_STATEMENT_TIMEOUT_MS | No | Postgres query timeout in milliseconds | 15000 |
| DUCKDB_MAX_TEMP_DIR_SIZE | No | DuckDB temp directory size cap | 2GB |
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
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 | |
This server cannot be deployed
Maintenance
ActivityMaintained
ResponsivenessNo issues