PondPilot Interactive SQL Demo#

Run SQL queries directly in your browser using DuckDB WASM. All widgets share a single DuckDB instance.

Features#

✅ Shared DuckDB instance - All widgets on the page share the same instance
✅ Persistent state - Tables created in one widget are accessible in all others
✅ Load .duckdb files - Specify duckdb: "/data/file.duckdb" in frontmatter to preload data
✅ Theme auto-detection - Matches your site’s dark/light mode automatically
✅ Editable/Read-only - Control editing with data-editable parameter
✅ Keyboard shortcuts - Ctrl+Enter or Cmd+Enter to run queries
✅ No backend needed - Everything runs in your browser

Quick Start#

Click “Run” or press Ctrl+Enter (or Cmd+Enter on Mac):

SELECT 
    'Hello, World!' as greeting,
    42 as answer,
    CURRENT_DATE as today;