@graphscope/duckdb-admin

DuckDB CSV Query Tool

A powerful browser-based CSV data query tool built with DuckDB-WASM. This tool allows you to manage and query your CSV datasets directly in the browser using SQL, with no server required.

✨ Features

• 📊 Upload and manage multiple CSV datasets
• 🔍 Query data using standard SQL
• 💾 Persistent storage in the browser
• 📤 Export results in CSV, JSON, or TSV formats
• 🚀 Runs entirely in the browser
• 🔒 Privacy-focused: all data stays in your browser

🚀 Quick Start

npm run dev

Navigate to http://localhost:3000 to start using the application.

🛠️ Technical Stack

• DuckDB-WASM - SQL database running in the browser
• React - User interface framework
• Ant Design - UI component library
• IndexedDB - For persistent data storage
• Web Workers - For background data processing

SQL Examples

Here are some useful SQL query examples:

-- Basic query with limit
SELECT * FROM "my_dataset" LIMIT 100;

-- Filter data
SELECT * FROM "my_dataset" WHERE column_name > 100;

-- Aggregation with grouping
SELECT category, COUNT(*) as count, AVG(value) as average
FROM "my_dataset"
GROUP BY category
ORDER BY count DESC;

-- Join multiple datasets
SELECT a.*, b.additional_column
FROM "dataset_a" a
JOIN "dataset_b" b ON a.id = b.id;

🔒 Data Security & Privacy

• All data is stored locally in your browser
• No data is uploaded to any server
• Data persistence is handled by browser's IndexedDB
• Clearing browser data will remove stored datasets

🙏 Acknowledgments

• DuckDB - The amazing SQL database that makes this possible
• React - The UI framework
• Ant Design - The UI component library