duckboard-webmcp.alexmnahas.workers.dev

duckdb_sql

Execute DuckDB SQL in this tab's browser-local DuckDB-Wasm database. Use SQL to load, join, transform, aggregate, and sample data before presenting it. The session is stateful until the page reloads, so statements may create, query, update, or drop tables and views across calls. DATA SOURCES - Local files must first be selected or dropped by the user. They are registered under local/*; discover them with SELECT * FROM glob('local/*'). Query them with read_csv, read_json, read_parquet, or supported filename shorthand. - SQL may read public HTTPS data supported by DuckDB-Wasm. Browser CORS rules still apply: the remote server must allow this page to fetch the URL. - DuckDB-Wasm differs from native DuckDB in extension and filesystem support. Consult the Wasm documentation before relying on a native-only feature. RESULTS - Multi-statement SQL executes every statement and persists its changes; structuredContent contains only the final statement's result. - The response includes column names, DuckDB types, and JSON-safe rows in structuredContent. - Big integers and exact decimals are returned as strings. Binary values are base64 strings. FIRST-PARTY DUCKDB DOCUMENTATION - DuckDB-Wasm overview: https://duckdb.org/docs/stable/clients/wasm/overview - DuckDB-Wasm data ingestion: https://duckdb.org/docs/stable/clients/wasm/data_ingestion - DuckDB-Wasm extensions and browser limitations: https://duckdb.org/docs/stable/clients/wasm/extensions - SQL statements: https://duckdb.org/docs/stable/sql/statements/overview - SELECT syntax: https://duckdb.org/docs/stable/sql/query_syntax/select - SQL functions: https://duckdb.org/docs/stable/sql/functions/overview - Friendly SQL: https://duckdb.org/docs/stable/sql/dialect/friendly_sql - Data formats: https://duckdb.org/docs/stable/data/overview

Input schema

{
  "type": "object",
  "properties": {
    "sql": {
      "type": "string",
      "minLength": 1,
      "description": "DuckDB SQL to execute."
    }
  },
  "required": [
    "sql"
  ],
  "additionalProperties": false
}