SQL Studio: A Universal SQL Database Explorer Built with Rust

SQL Studio: A Universal SQL Database Explorer Built with Rust

Summary

SQL Studio is a versatile, single-binary SQL database explorer built with Rust, offering broad compatibility with databases like SQLite, PostgreSQL, MySQL, DuckDB, and Microsoft SQL Server. It provides a comprehensive set of features for database interaction, from schema overview to advanced query capabilities with rich IntelliSense. This tool simplifies database management and exploration across diverse environments.

Repository Info

Updated on March 21, 2026
View on GitHub

Tags

RustDatabase ExplorerSQL ClientPostgreSQLMySQLSQLiteDuckDBDeveloper Tools

Click on any tag to explore related repositories

Introduction

SQL Studio is an open-source, single-binary SQL database explorer crafted in Rust, designed to provide a unified interface for interacting with a wide array of database systems. It supports popular databases such as SQLite, libSQL, PostgreSQL, MySQL/MariaDB, ClickHouse, DuckDB, and Microsoft SQL Server, along with Parquet and CSV files. This powerful tool aims to streamline database exploration and management through a user-friendly interface and robust features.

Installation

Getting started with SQL Studio is straightforward, with pre-built binaries available for various operating systems.

Install prebuilt binaries via shell script (MacOS and Linux)

curl --proto '=https' --tlsv1.2 -LsSf https://github.com/frectonz/sql-studio/releases/download/0.1.51/sql-studio-installer.sh | sh

Install prebuilt binaries via powershell script (Windows)

powershell -ExecutionPolicy Bypass -c "irm https://github.com/frectonz/sql-studio/releases/download/0.1.51/sql-studio-installer.ps1 | iex"

Nix

nix shell nixpkgs#sql-studio

Docker

A Docker image is available for easy deployment. Here's an example to run SQL Studio with the Postgres driver on port 3030:

docker run -p 3030:3030 frectonz/sql-studio /bin/sql-studio \
  --no-browser \
  --no-shutdown \
  --address=0.0.0.0:3030 \
  postgres \
  postgres://localhost:5432/

For updates, simply run:

sql-studio-update

Examples

SQL Studio offers simple command-line interfaces to connect to your databases. Here are a few examples:

Local SQLite DB File

sql-studio sqlite [sqlite_db]

PostgreSQL Server

sql-studio postgres [url]

MySQL/MariaDB Server

sql-studio mysql [url]

Local DuckDB File

sql-studio duckdb [duckdb_file]

Microsoft SQL Server

sql-studio mssql [connection]

For more connection options, including libSQL, Parquet, CSV, and ClickHouse, refer to the official documentation.

Why Use SQL Studio?

  • Broad Database Support: Connects to a wide range of SQL databases and file formats, including SQLite, PostgreSQL, MySQL, DuckDB, and more.
  • Single Binary: Simplifies deployment and usage with a single executable file.
  • Rich SQL IntelliSense: Enhances the querying experience with intelligent code completion and suggestions.
  • Intuitive User Interface: Features dedicated pages for overview, tables, and queries, providing a clear and efficient way to interact with your data.
  • Built with Rust: Leverages Rust's performance and safety benefits for a reliable and fast application.

Links

Explore SQL Studio further through these official resources: