- Category
- Developer Tools
- Rank
- No. 1831Tools index
Previous survey · No. 1839 ·
- Pricing
- Open Source
- Type
- TOOL
- Builder
- louislva
- GitHub
- 1 stars
- Date
About
Modern open-source database client for PostgreSQL — neat UI, diff-friendly schema browsing.
What it does
dbdiff is a desktop workspace for connecting to PostgreSQL, inspecting cached schema metadata, editing table data, running SQL, and comparing query results. It organizes databases and work into draggable tabs, with configurable keyboard shortcuts and CSV or SQL export paths.
Why it's ranked here
The tool has a focused, practical feature set for engineers who frequently inspect live PostgreSQL data. Query execution guards against stale responses, edits remain pending before submission, and schema metadata includes keys and indexes. Its source-built installation and macOS-focused packaging narrow the audience.
What's good
Table state tracks edits, new rows, deletions, sorting, filters, and pagination separately. Query tabs retain execution status, results, errors, and diff output. Shortcut handling adapts modifier keys across macOS and other browser environments. Local database scanning reduces connection setup, while CSV generation correctly quotes complex values.
Tradeoffs
PostgreSQL is the only declared database type. Installation builds the application from source and requires Node.js and npm. The supplied packaging configuration targets an unpacked macOS application rather than cross-platform installers. Cloud connection code exists, but its interface is explicitly disabled. Table pages use a fixed 500-row default.
How to use it well
Use dbdiff as a keyboard-oriented companion for exploring PostgreSQL schemas, checking data, making controlled row edits, and comparing query outputs during development. It best suits users comfortable installing from source. Do not choose it for multiple database engines or depend on its currently disabled cloud interface.
Technical notes+
package.json defines an ES module package with a React 19 and Vite frontend, an Express server, Electron entry point, PostgreSQL driver, Zustand state, CodeMirror SQL editing, and a macOS directory build target with archive packaging disabled. src/types.ts models PostgreSQL connections, schema metadata, query responses, row diffs, tab state, pending cell mutations, access levels, and exports. src/stores/hooks.ts shows race-protected query execution and platform-aware shortcut handling. src/stores/store.ts persists connection settings, theme, shortcut overrides, cloud credentials, and CSV preferences while keeping active tab and execution state session-only. src/App.tsx initiates schema synchronization for uncached connections, scans localhost when no configurations exist, validates cloud callback state, and bridges Electron menu actions. src/constants.ts disables cloud UI, enables localhost scanning, and fixes table pages at 500 rows.
Observed
- License
- The README describes dbdiff as free and open source; no specific license text is included in the supplied repository material.
- Primary language
- TypeScript and TSX are used across the application, state management, shared types, and server build configuration.
- Install surface
- Distributed as the dbdiff-app npm package, with source installation invoked through npx and requiring Node.js plus npm.
- Interface
- Desktop Electron application with a React interface and an Express-backed local API.
- Database support
- The declared database type is PostgreSQL only, using the pg driver.
- Platform packaging
- The supplied Electron build configuration targets an unpacked macOS application directory.
Read from README.md, package.json, src/App.tsx, src/main.tsx, src/types.ts, src/constants.ts, src/electron.d.ts, src/vite-env.d.ts, src/utils/csv.ts, src/stores/index.ts, src/stores/hooks.ts, src/stores/store.ts, src/components/index.ts, src/components/TabBar.tsx, src/components/Resizer.tsx.
What it can do
Connect to PostgreSQL database
Database connection credentials → Active database connection
Browse database schema
PostgreSQL database → Visual schema representation
Compare database schemas
Two PostgreSQL database schemas → Schema differences and changes
Execute SQL queries
SQL query statements → Query results and data
View database tables and structure
PostgreSQL database → Table definitions and relationships
Tags
Tech Stack
Comments (0)
No comments yet
Editorially curated, with community endorsements as a secondary signal. Corrections welcome.