Duckbase is a powerful in-browser data warehouse that transforms how you work with data. Built on DuckDB-WASM for high-performance OLAP (Online Analytical Processing), Duckbase delivers professional-grade analytics capabilities directly in your browser - no cloud setup, no database installation, no data leaving your device.
- 🔥 Significantly Faster than Google Sheets for large datasets (overcoming the 10M cell limitation)
- 🛡️ 100% Private - Your data never leaves your browser
- 💾 Zero Infrastructure - No database setup or server configuration required
- 🤖 AI-Enhanced - Smart SQL generation with cutting-edge language models
- 📊 Real-time Analytics - Fast insights on substantial datasets
- DuckDB-WASM Engine: High-performance analytical database running natively in WebAssembly
- OLAP Performance: Efficiently handle large datasets with fast query response times
- Memory-Efficient: Process substantial datasets using optimized streaming algorithms
- Browser-Native: Full SQL capabilities without server dependencies
- No Cell Limits: Unlike Google Sheets' cell restriction, process larger datasets seamlessly
- SQL Power: Full analytical SQL capabilities vs. limited spreadsheet formulas
- Columnar Processing: Optimized for analytical workloads vs. row-based spreadsheet or databases
- Data Type Optimization: Native support for complex data types and structures
- OpenRouter Integration: Access to Qwen, DeepSeek, OpenAI, and other cutting-edge models
- Smart Query Generation: Natural language to SQL conversion
- Query Optimization: AI suggests performance improvements and best practices
- Learning Assistant: Perfect for SQL learners and data professionals
- File Formats: CSV, JSON, XLSX, Parquet support
- Direct Loading: HTTPS URLs and S3 bucket integration
- Auto-Detection: Smart schema inference and data type detection
- Interactive Charts: Built-in Chart.js integration for stunning visualizations
- Export Options: CSV, JSON, XLSX, and Parquet export formats
- Client-Side Processing: All data operations happen in your browser
- Zero Data Transmission: Raw data never sent to external servers
- Secure AI: API keys protected on server-side, only results shared
- Local Storage: Complete control over your sensitive datasets
- No Setup Required: Skip complex database installations and cloud configurations
- Interactive Learning: Practice SQL with real datasets instantly
- AI Tutoring: Get explanations and suggestions for your queries
- Safe Environment: Experiment without breaking production systems
- Rapid Prototyping: Test hypotheses and explore data without infrastructure delays
- Data Wrangling: Clean, transform, and analyze datasets with powerful SQL
- Offline Capability: Work with sensitive data without cloud dependencies
- Next.js 15: React framework with App Router for optimal performance
- TypeScript: Type-safe development with enhanced developer experience
- Tailwind CSS: Utility-first CSS framework for rapid UI development
- Radix UI: Accessible, unstyled UI components for professional interfaces
- DuckDB-WASM: High-performance analytical database in WebAssembly
- Chart.js: Powerful charting library for data visualization
- XLSX.js: Excel file processing and generation
- OpenRouter: Unified API access to leading AI models
- Model Support: Qwen, DeepSeek, OpenAI GPT, and other cutting-edge free models
Try Duckbase instantly at duckbase.studio - no installation required!
- Node.js 18+ (Latest LTS recommended)
- npm or yarn package manager
- OpenRouter API Key (Free tier available)
-
Clone the repository:
git clone https://github.com/Saadain23/duckbase.git cd duckbase -
Install dependencies:
npm install
-
Start development server:
npm run dev
-
Open your browser: Navigate to http://localhost:3000
- Upload Data: Simply upload CSV, JSON, XLSX, or Parquet files into the browser
- URL Import: Load data directly from HTTPS URLs or S3 buckets
- Auto-Detection: Smart schema inference and data type detection
- Instant Loading: Data is processed and ready for analysis in seconds
- Natural Language: Ask questions like "I want to know sales trends by region"
- Smart SQL: AI generates optimized queries automatically
- Query Explanation: Get detailed explanations of generated SQL
- Learning Mode: Perfect for SQL beginners and professionals
- Custom Queries: Write complex SQL
- Real-time Results: Execute queries and see results instantly
- Interactive Charts: Visualize data with built-in Chart.js integration
- Export Options: Download results in CSV, JSON, XLSX, or Parquet formats
We welcome contributions from the community! Whether you're fixing bugs, adding features, or improving documentation, your help makes Duckbase better for everyone.
- Fork the repository and clone it locally
- Create a feature branch from the
devbranch - Make your changes following our coding standards
- Test thoroughly to ensure everything works
- Submit a pull request to the
devbranch
- Follow TypeScript best practices
- Use conventional commit messages
- Add tests for new functionality
- Update documentation as needed
- Ensure all linting passes
For detailed contribution guidelines, see our CONTRIBUTING.md file.
- Issues: Report bugs and request features on GitHub Issues
- Discussions: Join community discussions and ask questions
- Star: Show your support by starring the repository
This project is licensed under the MIT License - see the LICENSE file for details.
Built with ❤️ by Saadain
Website • GitHub • Issues • Contributing