A blazingly fast, lightweight PostgreSQL query tool for Windows
FastDB is a desktop application built with Tauri and React that provides a modern, high-performance interface for querying and managing PostgreSQL databases. Designed for speed and efficiency, it achieves sub-200ms startup times and handles result sets with 100,000+ rows without breaking a sweat.
- Multi-tab interface - Execute multiple queries simultaneously across different servers
- Smart caching - Schema metadata cached locally for instant tree navigation
- Query history - All successful queries saved per server
- Export results - One-click CSV export with proper escaping
- Click-to-copy - Copy any cell value with a single click
- Real-time search - Filter large result sets instantly
- Windows Credential Manager - Passwords stored securely in OS keychain, never in database
- No plaintext secrets - Zero passwords on disk
- Connection pooling - Efficient, secure connection reuse
- Material UI design - Clean, professional interface
- Keyboard shortcuts - Ctrl+Enter to execute, Tab for indentation
- Expandable tree - Server → Schema → Table → Column hierarchy
- Error handling - Clear, actionable error messages
- Responsive layout - Adapts to window size
- Windows 10/11 (required for Credential Manager)
- Node.js 18+ and npm 9+
- Rust 1.85+ (install via rustup)
- PostgreSQL server(s) to connect to
# Clone the repository
git clone https://github.com/tesmond/fastdb.git
cd fastdb
# Install frontend dependencies
npm install
# Build and run
npm run tauri dev# Build optimized release
npm run tauri build
# Find executable in:
# src-tauri\target\release\fastdb.exe- Click the + button in the server panel
- Enter connection details:
- Name (display name)
- Host (e.g., localhost or IP)
- Port (default: 5432)
- Database name
- Username
- Password (stored securely in Windows Credential Manager)
- Click Test Connection to verify
- Click Save
- Select a server from the left panel
- Click + to create a new query tab
- Type your SQL query
- Press Ctrl+Enter or click ▶ Execute
- View results in the bottom panel
| Shortcut | Action |
|---|---|
Ctrl+Enter |
Execute query |
Tab |
Insert 2 spaces (indent) |
Ctrl+T |
New tab (future) |
Ctrl+W |
Close tab (future) |
Frontend:
- React 18.2 with hooks
- Vite 5.0 for blazing fast builds and HMR
- Material-UI 5.11 for components
- react-window for virtualization
- Tauri API for backend communication
Backend:
- Rust with Tokio async runtime
- rusqlite for local metadata storage
- tokio-postgres for database connections
- deadpool-postgres for connection pooling
- Windows Credential Manager for password storage
- Edit columns with primary ID
- Server management UI (add/edit/delete)
- Saved queries with folders
- Advanced filtering (type-specific)
- Export to JSON/Excel
- Dark mode theme
- Query plan visualization (EXPLAIN)
- Multi-statement execution
- Transaction management
- Schema comparison tools
- Cross-platform support (macOS, Linux)
Contributions are welcome! Please feel free to submit a Pull Request.
# Install dependencies
npm install
# Run in development mode
npm run tauri dev
# Build for production
npm run build
# Format code
cargo fmt# Run unit tests once
npm test
# Run unit tests in watch mode
npm run test:watch
# Run unit tests once with coverage
npm run test:coverage- Rust: Follow standard Rust conventions (rustfmt)
- JavaScript: ESLint + Prettier configuration
- Commits: Conventional Commits format
MIT License - see LICENSE file for details
- Tauri - Desktop app framework
- Vite - Next generation frontend tooling
- Material-UI - React component library
- rusqlite - SQLite bindings
- tokio-postgres - PostgreSQL driver
- react-window - Virtualization library
- Issues: GitHub Issues
- Discussions: GitHub Discussions
- ✅ Phase 1: Architecture & Design (Complete)
- ✅ Phase 2: Backend Core (Complete)
- ✅ Phase 3: Frontend UI (Complete)
- ✅ Phase 4: Advanced Features (Complete)
- 🚧 Phase 5: Management (In Progress)
Current Version: 0.2.0
Status: Beta
Last Updated: 2026
Built with ⚡ Vite, React, and Rust