Enables read-only SQL querying and exploration of data files (CSV, Parquet, JSON, Excel, etc.) via DuckDB, supporting local paths, globs, URLs, and S3 buckets.
A minimal MCP server that provides a persistent DuckDB SQL engine to AI assistants, enabling natural-language querying of CSVs, Parquet, and cloud data with 12 tools and optional read-only mode.
Connect to a different DuckDB or MotherDuck database. Use absolute paths for local files, or :memory:, md:, or s3:// paths, and optionally create missing local files.
List all configured database connections to discover available options and select one for use. Returns connection names, types, and details without exposing passwords.
Check a semantic layer project for correctness across parse, runtime, examples, tests, and release modes to catch errors before trusting analytics answers.
Join two spatial datasets using intersects, within, or contains predicates, with automatic engine selection and warnings for empty or non-overlapping results.
Resolves a specific provision of an Australian Act or instrument by its citation, returning the provision text with provenance from installed local data modules.