DuckPond MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DUCKPOND_THREADS | No | Number of threads for DuckDB. | 4 |
| DUCKPOND_DATA_DIR | No | Local data directory for storage. | ~/.duckpond/data |
| DUCKPOND_STRATEGY | No | Storage strategy: parquet, duckdb, or hybrid. | duckdb |
| DUCKPOND_R2_BUCKET | No | R2 bucket name. | |
| DUCKPOND_S3_BUCKET | No | S3 bucket name. | |
| DUCKPOND_S3_REGION | No | S3 region (e.g., us-east-1). | |
| DUCKPOND_CACHE_TYPE | No | Cache type: disk, memory, or noop. | disk |
| DUCKPOND_JWT_SECRET | No | Secret for signing JWTs (auto-generated if not set). | |
| DUCKPOND_UI_ENABLED | No | Enable DuckDB UI (can also use --ui flag). | false |
| DUCKPOND_OAUTH_EMAIL | No | Email for OAuth user. | |
| DUCKPOND_S3_ENDPOINT | No | Custom S3 endpoint (for MinIO, etc.). | |
| DUCKPOND_DEFAULT_USER | No | Default user ID for DuckDB UI auto-start. | |
| DUCKPOND_MEMORY_LIMIT | No | Memory limit for DuckDB. | 4GB |
| DUCKPOND_OAUTH_ENABLED | No | Enable OAuth 2.0 authentication for HTTP transport. | false |
| DUCKPOND_OAUTH_USER_ID | No | Default user ID for OAuth. | |
| DUCKPOND_R2_ACCOUNT_ID | No | R2 account ID for cloud storage. | |
| DUCKPOND_JWT_EXPIRES_IN | No | JWT token expiration in seconds (default 1 year). | 31536000 |
| DUCKPOND_OAUTH_PASSWORD | No | Password for OAuth authentication. | |
| DUCKPOND_OAUTH_USERNAME | No | Username for OAuth authentication. | |
| DUCKPOND_BASIC_AUTH_EMAIL | No | Email for Basic Auth user. | |
| DUCKPOND_EVICTION_TIMEOUT | No | Idle timeout in milliseconds before eviction. | 300000 |
| DUCKPOND_MAX_ACTIVE_USERS | No | LRU cache size for multi-tenant users. | 10 |
| DUCKPOND_R2_ACCESS_KEY_ID | No | R2 access key ID. | |
| DUCKPOND_S3_ACCESS_KEY_ID | No | S3 access key ID. | |
| DUCKPOND_BASIC_AUTH_USER_ID | No | Default user ID for Basic Auth. | |
| DUCKPOND_BASIC_AUTH_PASSWORD | No | Password for Basic Authentication. | |
| DUCKPOND_BASIC_AUTH_USERNAME | No | Username for Basic Authentication. | |
| DUCKPOND_R2_SECRET_ACCESS_KEY | No | R2 secret access key. | |
| DUCKPOND_S3_SECRET_ACCESS_KEY | No | S3 secret access key. |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {} |
| logging | {} |
| completions | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| queryC | Execute a SQL query for a specific user and return results |
| executeA | Execute SQL statement (DDL/DML) for a specific user without returning results |
| getUserStatsA | Get statistics about a user's database (memory usage, query count, etc.) |
| isAttachedB | Check if a user's database is currently cached in memory |
| detachUserA | Manually detach a user's database from the cache to free resources |
| listUsersB | List all currently cached users and cache statistics |
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
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/jordanburke/duckpond-mcp-server'
If you have feedback or need assistance with the MCP directory API, please join our Discord server