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 |
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
- 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/amararun/shared-fastapi-database-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server