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) |
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| super_info | 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_status | 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_help | 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_query | Execute a SuperDB/SuperSQL query on data files. Returns structured results without shell escaping issues. |
| super_validate | Validate SuperSQL query syntax without executing. Returns diagnostics with position info and migration suggestions for common zq-to-SuperDB errors. |
| super_schema | Inspect the schema/types of a data file by finding all unique shapes (record types) with counts and examples. |
| super_db_list | List all pools in a SuperDB database. |
| super_db_query | Query data from a SuperDB database pool. |
| super_db_load | Load data into a SuperDB database pool. |
| super_db_create_pool | Create a new pool in a SuperDB database. |
| super_test_compat | Test a query against multiple SuperDB versions to detect syntax breaking changes. Useful for migration testing. |
| super_complete | Get code completions for a SuperSQL query at a position. Requires SUPERDB_LSP_PATH to be set. |
| super_docs | 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. |