Why I Built Yet Another SQL Client (And Made It Open Source)

The Problem ## The Existing Options ## Enter data-peek ## Core Features ## What's In ## What's Out (Intentionally) ## Why Open Source? ## 1. I Use Open Source Every Day ## 2. Trust Through Transparency ## 3. Community Makes It Better ## 4. Sustainable Business Model ## The Tech Stack (Preview) ## What's Next? ## Try It Out There are dozens of SQL clients out there. pgAdmin, DBeaver, DataGrip, TablePlus, Postico, Beekeeper Studio... the list goes on. So why build another one? Because I was frustrated. And sometimes frustration is the best motivation. Here's my typical workflow as a developer: I didn't need an enterprise-grade database administration tool. I needed something that: The pattern was clear: I wanted all four: fast, simple, multi-database, and free (for personal use). So I built it. A SQL client with a simple philosophy: Simple over feature-rich. Keyboard-first. Fast to open and query. Here's what it looks like: That's it. Schema browser on the left, query editor on top, results on bottom. I could have kept this private or made it fully paid. But here's my thinking: My entire career is built on open source. PostgreSQL, React, TypeScript, Node.js, Linux... I've benefited enormously from others' contributions. This is my way of giving back. A database client has access to your credentials and data. Would you trust a closed-source app from a solo developer? I wouldn't. With open source, you can: I've already received pull requests that fixed bugs I didn't know existed and added features I hadn't thought of. The community sees edge cases I never would. data-peek is free for personal use. Commercial use requires a license. This lets: It's the same model as many successful open source projects. I'll do a deep dive in the next post, but here's the overview: This is the first post in a series where I'll share: data-peek is available now: If you try it, I'd love to hear your feedback. Open an issue, start a discussion, or just star the repo if you think it's useful. And if you're frustrated with your current SQL client too... maybe it's time to peek at something simpler. Next up: The Tech Stack Behind data-peek: Modern Desktop Development in 2025 Templates let you quickly answer FAQs or store snippets for re-use. Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink. Hide child comments as well For further actions, you may consider blocking this person and/or reporting abuse COMMAND_BLOCK: ┌─────────────────────────────────────────────────────────────┐ │ [Connection ▾] [Settings] [AI] │ ├──────────────┬──────────────────────────────────────────────┤ │ │ │ │ Schemas │ SELECT * FROM users │ │ └─ public │ WHERE created_at > '2024-01-01' │ │ └─ users │ ORDER BY id DESC │ │ └─ posts │ LIMIT 100; │ │ └─ ... │ │ │ │ [Cmd+Enter to execute] │ │ ├──────────────────────────────────────────────│ │ │ id │ name │ email │ created_at │ │ │ ───┼───────┼────────────────┼──────────── │ │ │ 42 │ Alice │ [email protected] │ 2024-03-15 │ │ │ 41 │ Bob │ [email protected] │ 2024-03-14 │ │ │ │ └──────────────┴──────────────────────────────────────────────┘ Enter fullscreen mode Exit fullscreen mode COMMAND_BLOCK: ┌─────────────────────────────────────────────────────────────┐ │ [Connection ▾] [Settings] [AI] │ ├──────────────┬──────────────────────────────────────────────┤ │ │ │ │ Schemas │ SELECT * FROM users │ │ └─ public │ WHERE created_at > '2024-01-01' │ │ └─ users │ ORDER BY id DESC │ │ └─ posts │ LIMIT 100; │ │ └─ ... │ │ │ │ [Cmd+Enter to execute] │ │ ├──────────────────────────────────────────────│ │ │ id │ name │ email │ created_at │ │ │ ───┼───────┼────────────────┼──────────── │ │ │ 42 │ Alice │ [email protected] │ 2024-03-15 │ │ │ 41 │ Bob │ [email protected] │ 2024-03-14 │ │ │ │ └──────────────┴──────────────────────────────────────────────┘ COMMAND_BLOCK: ┌─────────────────────────────────────────────────────────────┐ │ [Connection ▾] [Settings] [AI] │ ├──────────────┬──────────────────────────────────────────────┤ │ │ │ │ Schemas │ SELECT * FROM users │ │ └─ public │ WHERE created_at > '2024-01-01' │ │ └─ users │ ORDER BY id DESC │ │ └─ posts │ LIMIT 100; │ │ └─ ... │ │ │ │ [Cmd+Enter to execute] │ │ ├──────────────────────────────────────────────│ │ │ id │ name │ email │ created_at │ │ │ ───┼───────┼────────────────┼──────────── │ │ │ 42 │ Alice │ [email protected] │ 2024-03-15 │ │ │ 41 │ Bob │ [email protected] │ 2024-03-14 │ │ │ │ └──────────────┴──────────────────────────────────────────────┘ - Need to check something in the database - Open SQL client - Wait... and wait... (why is it loading plugins?) - Navigate through 47 menu options to find the query window - Write a simple SELECT * FROM users LIMIT 10 - Get results buried under toolbars, status bars, and panels I never use - Opens fast - Under 2 seconds, not 20 - Gets out of my way - Query editor front and center - Supports multiple databases - I work with PostgreSQL, MySQL, and SQL Server - Has keyboard shortcuts - Cmd+Enter to run, Cmd+K to navigate - Looks decent - Dark mode that doesn't burn my eyes at 2 AM - Free tools = slow and bloated - Fast tools = paid (and sometimes still bloated) - Simple tools = single database only - Multi-tab query editor with Monaco (VS Code's editor engine) - PostgreSQL, MySQL, SQL Server support - Schema explorer with tables, views, columns, and stored procedures - Query history with execution time and row counts - Saved queries for frequently used SQL - Data export to CSV and JSON - Inline editing - Edit rows directly in the results table - ERD visualization - See your table relationships - AI assistant - Natural language to SQL (bring your own API key) - Dark mode - Because of course - Database administration tools - User management UI - Backup/restore wizards - 47 toolbar buttons - Plugin systems - Startup splash screens - Feature bloat - Audit the code - See exactly how credentials are stored - Verify no telemetry or data collection - Build from source if you're paranoid (respect) - Individual developers use it for free forever - Companies that get value from it contribute financially - Me to keep maintaining and improving it - Electron - Cross-platform desktop (macOS, Windows, Linux) - React 19 - UI with modern hooks and concurrent features - TypeScript - Strict mode, because runtime errors are my nemesis - Zustand - State management that doesn't make me cry - Monaco - The editor that powers VS Code - Tailwind CSS 4 - Styling without the CSS file chaos - The tech stack decisions and why I made them - The database adapter pattern for multi-DB support - Adding AI without vendor lock-in - Building the ERD visualizer with collision detection - Parsing SQL across dialects (harder than you'd think) - GitHub: github.com/Rohithgilla12/data-peek - Downloads: macOS, Windows, Linux binaries in releases - License: MIT (free for personal use)