A modern, cross-platform SQL editor with AI-powered query generation
Features • Screenshots • Installation • Development • Roadmap
GeminiSQL is a lightweight, fast, and intuitive SQL editor built with modern technologies. It combines the power of a native desktop application with AI capabilities to help you write SQL queries faster and more efficiently.
Built with Tauri 2.0, React 19, and Rust, GeminiSQL delivers a native experience with minimal resource usage while providing powerful features for database management.
- Multi-tab Query Editor - Work on multiple queries simultaneously with a tabbed interface
- Intelligent SQL Autocomplete - Context-aware suggestions for tables, columns, and SQL keywords
- Schema Browser - Explore database tables, columns, and relationships at a glance
- Query Results Viewer - View query results in a fast, virtualized table with column type indicators
- Save & Organize Queries - Save frequently used queries for quick access
- Query History - Access previously executed queries with timestamps and execution times
- AI Query Generation - Describe what you need in plain English, get SQL queries instantly
- Query Explanation - Understand what generated queries do with AI-powered explanations
- Multiple AI Models - Choose from Gemini 2.5 Pro, Gemini 2.5 Flash, or Gemini 3 Pro Preview
- Schema-Aware Generation - AI understands your database structure for accurate query generation
- Dark/Light Theme - Easy on the eyes with system theme detection
- Keyboard Shortcuts - Run queries (Cmd+Enter), save (Cmd+S), and more
- Connection Management - Save multiple database connections with color coding
- Real-time Connection Status - Always know your connection state
Intelligent autocomplete with table and column suggestions
Organize your queries with names and descriptions
Generate SQL queries from natural language descriptions
Download the latest release for your platform from the Releases page.
| Platform | Download |
|---|---|
| macOS (Apple Silicon) | GeminiSQL_x.x.x_aarch64.dmg |
| macOS (Intel) | GeminiSQL_x.x.x_x64.dmg |
| Windows | GeminiSQL_x.x.x_x64-setup.exe |
| Linux (Debian/Ubuntu) | GeminiSQL_x.x.x_amd64.deb |
| Linux (AppImage) | GeminiSQL_x.x.x_amd64.AppImage |
See the Development section below.
# Clone the repository
git clone https://github.com/yourusername/geminisql.git
cd geminisql
# Install dependencies
npm install
# Run in development mode
npm run tauri dev
# Build for production
npm run tauri build| Layer | Technology |
|---|---|
| Frontend | React 19, TypeScript, Tailwind CSS |
| Editor | CodeMirror 6 |
| State Management | Zustand |
| Backend | Rust, Tauri 2.0 |
| Database Drivers | SQLx (MySQL) |
| AI Integration | Google Gemini API |
To use the AI-powered query generation feature, you need to create a Google API key:
- Visit Google AI Studio
- Sign in with your Google account
- Click "Create API Key"
- Copy the generated API key
- In GeminiSQL, click the Settings icon (gear) in the top-right corner
- Paste your API key in the "Google API Key" field
- Select your preferred AI model (Gemini 2.5 Pro, 2.5 Flash, or 3 Pro)
Settings page with API key and model selection
Note: API usage costs are billed directly to your Google account. GeminiSQL does not store or proxy your API requests - all AI calls are made directly from your device to Google's API. Check Google AI pricing for current rates.
- Click "New Connection" in the header
- Select MySQL as the database type
- Enter your connection details
- Click "Test Connection" to verify
- Click "Save & Connect"
- PostgreSQL Support - Full support for PostgreSQL databases
- SSH Tunneling - Connect to databases through SSH tunnels for secure remote access
- Additional LLM Providers - Support for OpenAI, Anthropic Claude, and other AI providers
- Query Formatter - Auto-format SQL queries for better readability
- Export Results - Export query results to CSV, JSON, and Excel formats
Contributions are welcome! Please feel free to submit a Pull Request.
- Fork the repository
- Create your feature branch (
git checkout -b feature/amazing-feature) - Commit your changes (
git commit -m 'Add some amazing feature') - Push to the branch (
git push origin feature/amazing-feature) - Open a Pull Request
This project is licensed under the MIT License - see the LICENSE file for details.
- Built with Tauri
- SQL editing powered by CodeMirror
- AI capabilities powered by Google Gemini
- Icons from Lucide
100% vibe coded with Claude Code
Made with Rust and React