dbx
lightweight database client studio with dialect-aware query
dbx!!!!!!!!!!!!!!!!!!!! — lightweight database client studio with dialect-aware query builder and visual filter designer
How to use dbx
- Save a demo connection in the Connect tab and pick its database type
- Open the Query builder, set the table and row limit
- Add filter rules with columns, operators and AND/OR conjunctions
- Review the dialect-aware SQL generated for your database
- Copy the SQL or browse the filtered rows in the Table viewer tab
Features
- Simulated connection manager for MySQL, PostgreSQL, SQLite, SQL Server, Oracle and more
- Dialect-aware SELECT builder ported from the upstream: TOP, LIMIT, ROWNUM, FETCH FIRST, FIRST, ROWS
- Visual filter-rule builder assembling structured WHERE clauses with AND/OR nesting
- Table viewer with a demo dataset filtered live by your rules
- Copyable generated SQL with per-dialect limit style shown
- Quick action: select first 10 rows in the active dialect
Frequently asked questions
Is it free?
Yes, unlimited.
Login to use this free online tool. Create a free account to get started.