DataZen

The lightweight, open-source AI database client for developers

Natural-language SQL · Query analysis · Charts · Workflows · MCP · Extensible drivers

Download · Website · 中文 · Contributing

DataZen is a desktop database client built with Tauri + Rust. It combines the everyday database tools developers expect with AI-assisted querying, visual analysis, automation, and a compile-time driver architecture.

• Lightweight — Tauri + Rust keeps the application small and responsive.
• AI-native — generate SQL, diagnose errors, understand execution plans, and work with database context through chat.
• Visual — turn query results into charts without exporting to another tool.
• Automatable — compose SQL and AI operations into reusable YAML workflows across databases.
• Extensible — database drivers are integrated at compile time through the DataZen Driver API.
• Local-first — credentials and database access stay on your machine.
• Open source — GPLv3, with an architecture designed for community drivers and contributions.

Write and run SQL in a modern editor, inspect results, browse tables, and move between query results and visualizations without leaving DataZen.

DataZen puts AI next to the database instead of making you copy schema and errors into another application.

Natural language → SQL

Describe what you need and DataZen uses the current database schema as context to generate executable SQL. Generated SQL can be executed immediately or inserted into the editor for further editing.

SQL error diagnosis

When a query fails, AI can combine the database error and schema context to explain the problem and propose corrected SQL.

EXPLAIN analysis

Visualize execution plans and use AI to identify bottlenecks, scan strategies, and optimization opportunities.

Database-aware AI Chat

The AI sidebar can work with the current connection's schema and turn SQL from the conversation into editor-ready code.

Supported AI integrations include OpenAI, Anthropic, DeepSeek, and compatible custom endpoints.

You should not need to export data to Excel just to understand it. DataZen can infer useful chart configurations from query results and switch between table and chart views.

Supported visualizations include line, bar, pie, scatter, and area charts, with aggregation, grouping, and PNG/SVG export.

DataZen Workflows describe reusable database operations in YAML. A workflow can combine queries, AI steps, conditions, and loops, with each step connected to the database it needs.

For example, one workflow can query orders from PostgreSQL, fetch logistics from MySQL, and let AI summarize the combined result.

Workflows can be started from the UI, the AI sidebar, MCP, or generated with AI.

DataZen works both as an MCP Server and an MCP Client.

Expose database operations, schema inspection, EXPLAIN, and workflows to external AI agents. DataZen also provides a headless stdio mode for automation and agent integrations.

Connect external MCP servers to DataZen AI Chat and bring additional tools and context into database conversations.

This makes DataZen useful not only as a GUI, but also as a database tool inside larger AI-assisted development workflows.

DataZen separates the application from database-specific implementation through the DataZen Driver API.

                         DataZen
                            │
              ┌─────────────┴─────────────┐
              │       DataZen Core        │
              │  UI · Query · AI · MCP   │
              └─────────────┬─────────────┘
                            │
                    DataZen Driver API
                            │
          ┌─────────────────┼─────────────────┐
          │                 │                 │
       PostgreSQL         MySQL          External drivers
                                           │
                              ┌────────────┼────────────┐
                              │            │            │
                           MongoDB      ClickHouse    OLAP...

Drivers are compiled into DataZen rather than loaded through an unstable Rust dynamic-library ABI. This allows a driver to provide both Rust database functionality and frontend UI while still remaining in its own repository.

A driver can be developed in an independent repository next to a local DataZen checkout:

workspace/
├── datazen/
└── datazen-driver-mydb/

During development, DataZen's driver registry can point to the local repository with source: "path". The DataZen application is then built with the selected driver, giving plugin developers a real host for both backend and frontend debugging.

The Driver API itself is maintained in packages/driver-api and published as the MIT-licensed datazen-driver-api crate. Independent drivers normally consume the published crate and do not need to clone DataZen just to obtain the API.

See the complete guides:

• Independent Plugin Development — English
• 独立插件开发指南 — 中文
• Driver API crate README
• Driver API dependency boundary
• datazen-driver-api on crates.io

DataZen ships with a small default set and can be built with additional drivers.

The exact driver set is controlled at build time, so a distribution does not have to ship every database engine.

Download the latest release from GitHub Releases.

DataZen is free and does not require an account.

• Node.js >= 20
• pnpm >= 9
• Rust >= 1.77
• Tauri v2 system dependencies

pnpm install
pnpm tauri dev

Build only the drivers you need:

# Default driver set
pnpm tauri:build

# All supported path drivers
DATAZEN_DRIVERS=all pnpm tauri:build

# Custom driver set
DATAZEN_DRIVERS=postgres,mongodb pnpm tauri:build

DataZen is designed around local database access:

• Database credentials are stored locally.
• AI requests are sent to the provider configured by the user.
• Database data is not uploaded to a DataZen cloud service.
• SSH connections can be established directly from the application.

Always review the privacy and security policies of the AI provider and endpoint you configure.

• Project website
• Independent Plugin Development
• Chinese Plugin Development Guide
• Driver API crate
• Driver API dependency boundary
• datazen-driver-api on crates.io
• Workflow Guide
• Contributing

DataZen welcomes bug reports, feature requests, database drivers, documentation improvements, and code contributions.

Please read CONTRIBUTING.md before opening a pull request. Driver work should generally be developed in an independent driver repository and integrated through the DataZen driver registry.

DataZen is licensed under the GNU General Public License v3.0. The datazen-driver-api crate under packages/driver-api is separately licensed under the MIT License. See LICENSE and packages/driver-api/LICENSE-MIT.