DC QueryStudio

Free Software

FREE

DC QueryStudio

Cross-Platform Database Query Tool with Built-In AI Assistant

A desktop database client for MySQL, PostgreSQL, SQLite, and SQL Server. It includes an AI assistant that understands your actual schema, so it writes queries using your real table names and columns. You can also generate ERD diagrams, edit data inline, and export results in multiple formats. Free, offline, no account needed.

Version 0.1.0 February 28, 2026 3 downloads
DC QueryStudio screenshot
Full interface: SQL editor, results grid, AI assistant, and object browser

Most database tools are either expensive and bloated, or too simple to be useful. You end up jumping between a query editor, a browser for schema docs, ChatGPT for SQL help, and a spreadsheet for exports. It should all be in one place.

DC QueryStudio puts a SQL editor, AI assistant, ERD viewer, data editor, and export tool into one desktop app. The AI knows your actual database schema, not just generic SQL, so it writes queries that work on the first try.

Download DC QueryStudio

Select your platform and accept the terms to download.

4 platforms available. Select your platform above.

Interface Overview

Here's what each part of the interface does.

DC QueryStudio interface with numbered annotations

Sidebar

  • 1 Current Active Connection
  • 2 Connection Panel
  • 3 Add New Connection
  • 31 Current Connection Indicator
  • 35 Query History Tab
  • 36 Favorites Tab
  • 32 SQL Query History
  • 33 Filter History by Connection
  • 34 Search Query History

SQL Editor

  • 4 Query Tabs
  • 5 Current Active Tab
  • 9 Connection Used by Tab
  • 10 Selected Database
  • 11 Execute SQL Query
  • 6 Save to Favorites (Cmd+S)
  • 7 Explain Query (AI)
  • 8 Optimize Query (AI)

Results

  • 12 Results Tab
  • 13 Messages Tab
  • 14 Result Grid
  • 15 Export Result Grid Data

AI Assistant

  • 16 AI Assistant Panel
  • 22 Select LLM Model
  • 17 Embedding Indexing Status (Green = Ready)
  • 18 Toggle Embedding Panel
  • 19 Toggle AI Chat History
  • 20 Start New AI Chat
  • 21 Close AI Assistant Panel
  • 23 Run Generated SQL Query
  • 24 Select AI Task (Generate / Explain / Optimize)
  • 25 AI Chat Input Box
  • 26 Attach File to AI Chat

Status Bar

  • 27 Toggle Light/Dark Theme
  • 28 Open About Dialog
  • 29 Open Settings
  • 30 Open AI Assistant Panel
Multi-Database Support
🟠

MySQL

Full MySQL support with INFORMATION_SCHEMA introspection, SSL connections, and SSH tunneling for secure remote access.

🔵

PostgreSQL

PostgreSQL support with pg_catalog queries, per-database connection pools, and schema-level object browsing.

🟢

SQLite

Local SQLite databases via file picker. Browse tables using sqlite_master and PRAGMA introspection.

SQL Editor
✏️

Monaco Editor

Powered by the same editor engine as VS Code. Syntax highlighting, auto-complete, and per-engine awareness.

📋

Multi-Tab Editing

Work on multiple queries simultaneously. Each tab binds to its own connection and database with a color-coded dot.

▶️

Execute Selection

Highlight a portion of SQL and press Cmd+Enter to run just that part. Full keyboard-driven workflow.

AI Assistant
✨

Generate SQL

Describe what you want in plain English and the AI writes the query using your actual table names and columns.

💡

Explain Queries

Paste a complex query and get a plain-English breakdown of what each clause does.

⚡

Optimize Queries

Submit a slow query and receive optimization suggestions based on your database schema and indexes.

Schema Intelligence
🧠

Schema Embeddings

Index your database schema into vector embeddings so the AI knows your tables, columns, and relationships.

🗺️

Visual ERD Diagrams

Generate interactive entity-relationship diagrams from your live database with auto-layout and export.

🌳

Object Browser

Lazy-loading tree showing databases, tables, views, stored procedures, functions, indexes, and triggers.

Data Management
📝

Editable Grid

Edit First 500 Rows: double-click cells to edit inline, add/delete rows, and apply changes with generated SQL.

📤

Export Formats

Export results as CSV, JSON, Excel (.xlsx), XML, SQL INSERT statements, or copy to clipboard.

🗂️

Table Operations

Right-click tables to open, edit, delete, empty, truncate, duplicate, dump SQL, rename, or view DDL.

Cross-Platform
💻

macOS & Windows

Native builds for macOS (Apple Silicon and Intel) and Windows (MSI installer or NSIS setup).

🤖

Multiple LLM Providers

Choose from OpenAI, Anthropic, Google, ChatGPT, or any local LLM server (Ollama, LM Studio).

🌙

Dark & Light Themes

Toggle between dark and light themes with a single click. Deep navy-charcoal dark or clean white light.

See It In Action

Explore the interface with screenshots of each feature.

AI Assistant generating SQL queries with schema-aware context and actionable buttons
View Full Size
AI Assistant generating SQL queries with schema-aware context and actionable buttons
AI Chat with file attachments. Share screenshots, SQL files, and CSVs for context
View Full Size
AI Chat with file attachments. Share screenshots, SQL files, and CSVs for context
Visual ERD diagram showing all tables, columns, and relationships in the database
View Full Size
Visual ERD diagram showing all tables, columns, and relationships in the database
Dark theme with results grid showing employee data from a PostgreSQL database
View Full Size
Dark theme with results grid showing employee data from a PostgreSQL database
New MySQL connection form with host, port, SSL, and SSH tunnel options
View Full Size
New MySQL connection form with host, port, SSL, and SSH tunnel options
New PostgreSQL connection form with color-coded engine identity
View Full Size
New PostgreSQL connection form with color-coded engine identity
New SQLite connection. Just browse to a database file
View Full Size
New SQLite connection. Just browse to a database file
New SQL Server connection with TDS protocol support
View Full Size
New SQL Server connection with TDS protocol support
Table context menu with Open, Edit, Delete, Dump SQL, View DDL, Show ERD, and more
View Full Size
Table context menu with Open, Edit, Delete, Dump SQL, View DDL, Show ERD, and more
Export results as CSV, JSON, Excel, XML, SQL INSERT, or copy to clipboard
View Full Size
Export results as CSV, JSON, Excel, XML, SQL INSERT, or copy to clipboard
Query history with search, connection filter, execution time, and row counts
View Full Size
Query history with search, connection filter, execution time, and row counts
Favorites panel with folder organization for saved queries
View Full Size
Favorites panel with folder organization for saved queries
Settings for theme, editor font size, query limits, timeout, NULL display, and date format
View Full Size
Settings for theme, editor font size, query limits, timeout, NULL display, and date format
AI settings for provider selection, API keys, embedding config, and Local LLM support
View Full Size
AI settings for provider selection, API keys, embedding config, and Local LLM support

Key Features

  • 4 database engines in one app. MySQL, PostgreSQL, SQLite, and SQL Server
  • AI Assistant with Generate, Explain, and Optimize modes that understands your actual schema
  • Visual ERD diagrams generated from live database schemas with auto-layout and export
  • Schema embedding indexing for context-aware AI responses using your real tables and columns
  • 5 LLM providers. OpenAI, Anthropic, Google, ChatGPT, and fully local/offline LLM
  • File attachments in AI chat. Share ERD screenshots, CSV data, SQL scripts, and PDF specs
  • Monaco-based SQL editor with syntax highlighting and multi-tab editing
  • Editable data grid for direct row manipulation with change tracking
  • Export to CSV, JSON, Excel, XML, and SQL INSERT statements
  • Query history with full-text search, connection filtering, and selective cleanup
  • Favorites with folder organization and AI few-shot learning context
  • Cross-platform. macOS (Intel and Apple Silicon) and Windows
  • Built with Rust backend for native performance, not Electron
  • Completely free, no ads, no account required

How It Works

1

Connect

Add your database connection. MySQL, PostgreSQL, SQLite, or SQL Server. Test it with one click.

2

Query

Write SQL in the editor or ask the AI to generate it. Browse your schema in the object tree.

3

Analyze & Export

View results in the grid, edit data inline, visualize with ERD diagrams, and export in any format.

Who Is This For?

DC QueryStudio is built for:

Backend Developers who need a fast, modern SQL client for daily database work

Database Administrators managing multiple databases across different engines

Data Analysts running queries with AI assistance to explore datasets

Students & Educators learning SQL with AI-powered explanation and query generation

Anyone who wants a lightweight, AI-powered alternative to heavy database tools

System Requirements

macOS

  • macOS 12+ (Monterey or later)
  • Apple Silicon (M1/M2/M3/M4) or Intel
  • ~50 MB disk space

Windows

  • Windows 10 or 11 (64-bit)
  • ~50 MB disk space
  • MSI installer or NSIS setup

All database connections are made directly from the app. No additional drivers or middleware needed.

Getting Started

  1. 1

    Download and install

    Run the DMG on macOS or MSI/Setup on Windows. Open the app and you're ready to go.

  2. 2

    Add a connection

    Click the + button in the sidebar, select your database engine, fill in credentials, and test the connection.

  3. 3

    Write and run queries

    Type SQL in the editor or ask the AI to generate it. Press Cmd+Enter to execute and see results instantly.

  4. 4

    Set up AI (optional)

    Open Settings, add an API key (OpenAI, Anthropic, Google) or connect to a local LLM. Index your schema for the best AI experience.

Changelog

v0.1.0 — Initial Release

  • Multi-database support: MySQL, PostgreSQL, SQLite, SQL Server
  • AI Assistant with Generate, Explain, and Optimize modes
  • Schema embedding indexing for context-aware AI responses
  • Multiple LLM providers: OpenAI, Anthropic, Google, ChatGPT, Local LLM
  • File attachments in AI chat (images, PDFs, SQL files, CSV)
  • Visual ERD diagrams from live database schemas
  • Monaco-based SQL editor with syntax highlighting
  • Multi-tab editing with per-tab connection binding
  • Editable data grid (Edit First 500 Rows)
  • Data export: CSV, JSON, Excel, XML, SQL INSERT
  • Query history with search and selective cleanup
  • Favorites with folder organization
  • Table context menu: Open, Edit, Delete, Empty, Truncate, Duplicate, Dump SQL, Rename, View DDL, Show ERD
  • Dark and light themes
  • macOS builds (Intel + Apple Silicon) with code signing and notarization
  • Windows builds (MSI + NSIS installer)

What's Next?

We're actively developing new features including:

  • SQL Server (MSSQL) full feature parity
  • Auto-complete with schema-aware suggestions
  • Query plan visualization (EXPLAIN ANALYZE)
  • Data import from CSV/JSON/Excel
  • Connection groups and workspaces
  • Linux support

Have a suggestion? We'd love to hear what features you need most.

Get Started Today

Download DC QueryStudio and work with your databases faster. The AI knows your schema.

Download Now
macOS Windows

Get Support

Report issues or ask questions
cta-image

Need a Custom Desktop Application?

We build modern, cross-platform desktop applications tailored to your business needs. From internal tools and data analyzers to customer-facing software. Tell us your requirements and we'll build a polished application.

Discuss Your Project