PondPilot is a blazing-fast, lightweight, 100% client-side AI-enabled data exploration tool that helps you analyze local & remote data with zero setup. Powered by DuckDB-Wasm and integrated AI assistance, it runs entirely in your browser - no install, no servers, no cloud uploads, complete privacy. Whether you're a data analyst, scientist, or engineer, PondPilot helps you get your data ducks in a row without the overhead of traditional data tools.

Traditional data tools have major drawbacks:

• They require complex setup and installation
• They often send your data to remote servers
• They're resource-intensive and can be slow for large datasets
• Many require paid subscriptions or have usage limits

PondPilot solves these problems by:

• Running entirely in your browser with zero installation
• Processing all data locally - your data never leaves your device
• Using DuckDB's lightning-fast SQL engine optimized for analytical queries
• Providing the ability to work directly with your files without making copies
• Being completely free and open-source

• 100% Client-Side: All processing happens in your browser - your sensitive data never leaves your device
• PWA Support: 📱 Install PondPilot as a Progressive Web App for offline use anywhere
• Read-only: ✅ PondPilot doesn't write to your files, guaranteeing data safety and integrity

• No data-copy: 🔄 Unlike similar tools, PondPilot accesses files directly without copying to browser cache - changes outside PondPilot are reflected in real-time
• Powered by DuckDB: 🚀 Leverage the lightning-fast SQL engine for analyzing millions of rows in seconds
• Cross-session persistence: 💾 All data-handles and queries are automatically saved between sessions

• Natural Language to SQL: 💬 Generate complex SQL queries from simple English descriptions
• Intelligent Error Fixing: 🔧 Automatic suggestions to fix SQL on errors
• Multiple AI Providers: 🔌 Support for OpenAI, Anthropic Claude, and custom OpenAI-compatible endpoints
• Privacy-First: 🔐 Uses your own API keys - your queries and data never leave your control
• Context-Aware: 🧠 Understands your database schema and provides relevant suggestions

• Multiple File Formats: 📊 Support for CSV, Parquet, JSON, XLSX, DuckDB database and more coming soon
• Interactive SQL Editor: 💻 Write and execute SQL queries with syntax highlighting, auto-completion, and error detection
• Data Visualization: 📈 View, filter, and sort your query results in a responsive interactive table
• Full-text Schema Explorer: 🔍 Easily navigate through tables and columns with auto-generated metadata [coming soon]

• Data Export: 📁 Export your query results to various formats for further analysis
• Keyboard Shortcuts: ⌨️ Navigate efficiently with intuitive keyboard shortcuts
• Dark/Light Mode: 🌓 Choose the interface that's easiest on your eyes

The easiest way to use PondPilot is through the hosted web app:

1. Visit https://app.pondpilot.io
2. Click "Add file" or use keyboard shortcut (Ctrl+F) to load your data
3. Start exploring!

PondPilot works across all major browsers with different feature sets:

• Chrome/Edge: Full functionality with file persistence and folder selection
• Firefox/Safari: Core features with session-only file access (files must be re-selected after refresh)

Run PondPilot with a single command:

docker run -d -p 4173:80 --name pondpilot ghcr.io/pondpilot/pondpilot:latest

Visit http://localhost:4173 in your browser to access the app.

Note: PWA and offline mode is disabled for the Docker version to avoid conflicts with other apps serving on localhost.

PondPilot supports deployment in subdirectories alongside other services. See DEPLOYMENT.md for detailed instructions on:

• Building with custom base paths (e.g., /custompath/, /pondpilot/)
• Configuring nginx reverse proxy
• Docker Compose examples

Alternatively, you can build & run PondPilot using Yarn:

# Clone the repository
git clone https://github.com/pondpilot/pondpilot.git
cd pondpilot

# Setup the project
corepack enable
yarn

# Start the development server
yarn dev

Visit http://localhost:5173 in your browser to access the app.

• Ctrl/⌘ + K: Open spotlight menu to navigate, add files, create new queries and explore shortcuts
• Ctrl + F: Add file to analyze
• Ctrl + D: Add DuckDB file
• Ctrl + I: Import SQL files
• In editor:
  • Ctrl/⌘ + Enter: Run the entire script
  • Ctrl/⌘ + Shift + Enter: Run the query under the cursor
  • Ctrl/⌘ + I: Open AI assistant for SQL generation and error fixes

The goal for PondPilot is to remain lightweight. We strive to quickly reach feature completeness and then accept only security fixes or updates to keep up with DuckDB.

Here is what we are planning before reaching feature completeness:

• Basic statistics & metadata view without the need to run queries (think data distribution, column types, etc.)
• Additional popular local & remote sources support: SQLite, MotherDuck

The official hosted version of PondPilot and the latest tag for our Docker image are continuously updated based on the main branch. However, we occasionally tag releases to mark significant milestones. You can read the draft release notes for the upcoming tagged version and all released versions on the release page or in the CHANGELOG.

We welcome contributions from the community! Here's how to get started:

1. Fork the repository
2. Create your feature branch (git checkout -b feature/amazing-feature)
3. Commit your changes (git commit -m 'Add some amazing feature')
4. Push to the branch (git push origin feature/amazing-feature)
5. Open a Pull Request

• React 19 with TypeScript
• Mantine UI components
• Tailwind CSS for styling
• DuckDB-WASM for data processing
• Vite for building

• yarn dev - Start development server
• yarn build - Build production version
• yarn test - Run Playwright tests
• yarn preview - Locally preview production build
• yarn typecheck - Check TypeScript types
• yarn lint - Run ESLint and Stylelint
• yarn lint:fix - Fix ESLint and Stylelint issues
• yarn prettier - Check formatting
• yarn prettier:write - Format code

DuckDB is awesome, and there are many similar proejcts out there. And there is even more SQL IDE's beyond that. We've been inspired by the following projects:

• Rill
• QuackDB
• TablePlus
• Outerbase Studio
• harlequin
• duck-ui

And many more!

PondPilot is licensed under the GNU Affero General Public License v3.0. See the LICENSE file for details.

This means you're free to use, modify, and distribute the software, but if you make changes and provide the software as a service over a network, you must make your source code available to users of that service.

• Built with DuckDB-WASM - the powerful SQL database that runs in your browser
• UI components by Mantine
• This project incorporates and modifies code related to query editor from Outerbase Studio which is licensed under the GNU Affero General Public License v3.0.

app.pondpilot.io • GitHub • Built at T1A with ❤️