DataAce is a fast, cross-platform desktop app for working with SQLite, MySQL, PostgreSQL, Oracle, and SQL Server. Built with Tauri for native performance.
Available for macOS • Windows • Linux
| id | name | role | created_at | deleted_at | |
|---|---|---|---|---|---|
| 1 | Alice | alice@example.com | admin | 2024-01-15 | NULL |
| 2 | Bob | bob@example.com | user | 2024-02-03 | NULL |
| 3 | Carol | carol@example.com | user | 2024-03-11 | NULL |
| 4 | Dave | dave@example.com | editor | 2024-04-22 | 2024-09-01 |
| 5 | Eve | eve@example.com | user | 2024-06-17 | NULL |
A focused tool built for developers and DBAs who work with real databases every day.
Paginated data viewer with filtering, sorting, and column resizing. Export any result set to CSV instantly.
Inspect columns, data types, nullability, default values, primary keys, and indexes at a glance.
Write and run raw SQL with syntax highlighting. Results appear instantly in a resizable grid below.
Visualize foreign key constraints and understand how tables relate to each other without writing any SQL.
View all triggers on a table, including event type (INSERT/UPDATE/DELETE), timing, and the trigger body.
Row count, disk size, storage engine, collation, and CREATE TABLE DDL — all in one place.
Save multiple connection profiles with color-coded labels. Organize by database type. Reconnect in one click.
Export entire databases as SQL dumps, CSV archives, or structured JSON. Choose structure-only or with data.
Follows your system preference automatically, or manually cycle between light, dark, and system modes.
Native drivers for every major relational database system — no JDBC, no ODBC, no overhead.
Open local .db / .sqlite files or use in-memory databases.
Connect to MySQL 5.7+ and MariaDB servers on any host and port.
Full support for PostgreSQL 12+ with schema-aware queries and type mapping.
Connect to Oracle Database with TNS or Easy Connect string support.
Microsoft SQL Server and Azure SQL with Windows or SQL authentication.
No configuration files, no CLI setup. Just download, open, and connect.
Download the installer for your platform from dataace.anunes.net. Available for macOS (.dmg), Windows (.msi), and Linux (.AppImage / .deb).
Click the + button in the sidebar to create a new connection profile. Give it a name, choose your database type, and fill in the host, port, username, and password. For SQLite, click the folder icon to browse for a file.
Click your connection in the sidebar to connect. The database tree populates with all databases and tables. Click any table to start browsing its data in the Browse tab.
Switch to the Query tab to open the SQL editor. Write any query, press Cmd+Enter (macOS) or Ctrl+Enter (Windows/Linux) to run it, and see results immediately below.
Use the tab bar to switch between Structure (columns & indexes), Relations (foreign keys), Triggers, and Info (row count, size, DDL) for any selected table.
Right-click a connection or use the export menu to save a full database export. Choose SQL, CSV, or JSON format, and optionally include or exclude data rows.
Free to use. No account required. No telemetry.
⇓ Get DataAce