SuperDB MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| SUPERDB_LSP_PATH | No | Path to SuperDB LSP binary (required for LSP tools: super_complete and super_docs) |
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 |
|---|---|
| super_infoA | Get SuperDB version info, environment configuration, LSP availability, and installation instructions. Call this to check setup status or learn how to install the optional LSP for enhanced query assistance. |
| super_lsp_statusA | Check if the SuperDB LSP is installed and get installation instructions if not. The LSP enables code completions and documentation lookup for SuperSQL queries. |
| super_helpA | Get SuperDB documentation. Call this before writing complex queries or when migrating from zq or earlier versions of SuperDB. Topics: expert (syntax guide), upgrade (zq migration). |
| super_queryC | Execute a SuperDB/SuperSQL query on data files. Returns structured results without shell escaping issues. |
| super_validateA | Validate SuperSQL query syntax without executing. Returns diagnostics with position info and migration suggestions for common zq-to-SuperDB errors. |
| super_schemaB | Inspect the schema/types of a data file by finding all unique shapes (record types) with counts and examples. |
| super_db_listC | List all pools in a SuperDB database. |
| super_db_queryC | Query data from a SuperDB database pool. |
| super_db_loadC | Load data into a SuperDB database pool. |
| super_db_create_poolC | Create a new pool in a SuperDB database. |
| super_test_compatB | Test a query against multiple SuperDB versions to detect syntax breaking changes. Useful for migration testing. |
| super_completeB | Get code completions for a SuperSQL query at a position. Requires SUPERDB_LSP_PATH to be set. |
| super_docsB | Get documentation for a symbol at a position in a SuperSQL query. Requires SUPERDB_LSP_PATH to be set. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
| SuperDB Expert Guide | Comprehensive guide for SuperDB queries, syntax patterns, and best practices. Read this before writing complex queries. |
| ZQ to SuperDB Upgrade Guide | Migration guide covering all breaking changes from zq to SuperDB. Essential for upgrading old scripts. |
TDQS
Scored across 13 tools
Most tools have distinct purposes, such as super_db_create_pool for pool creation and super_query for query execution, but there is some overlap between super_query and super_db_query (both involve querying data) and between super_docs and super_help (both provide documentation). The descriptions help clarify differences, but minor confusion could occur.
All tool names follow a consistent snake_case pattern with a 'super_' prefix, such as super_db_create_pool and super_validate. This uniformity makes the tool set predictable and easy to navigate, with no deviations in naming style.
With 13 tools, the count is well-scoped for a database server covering setup, querying, validation, and documentation. Each tool serves a specific function, such as super_info for setup checks and super_test_compat for migration testing, ensuring no redundancy or gaps in the core operations.
The tool set provides comprehensive coverage for SuperDB operations, including pool management (create, list, load), querying (query, validate), and setup assistance (info, lsp_status). Minor gaps exist, such as no explicit tools for updating or deleting pools, but core workflows like query execution and migration are well-supported.