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 read-only DuckDB MCP server offering context-efficient analytics tools (list_datasets, describe_table, profile_column, explain, query) with a semantic layer for business rules, security guards, and disclosed truncation to help LLMs produce correct answers while minimizing token usage.
Execute data quality validation rules from a YAML file against DuckDB, BigQuery, Athena, Databricks, or Postgres, returning a JSON report with optional LLM-driven root cause analysis.
Run read-only SQL queries on cached open data resources, including CSV, TSV, XLSX, JSON, and ODS files. Supports SELECT statements with row limits for safe analysis.
Profile a column's distribution, outliers, coverage gaps, and dirty values. Adapts to numeric, date, text, or boolean types to reveal skew, missing days, and formatting issues.