SQL Studio: A Universal SQL Database Explorer Built with Rust

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:

• GitHub Repository: https://github.com/frectonz/sql-studio
• Documentation: https://sql-studio-docs.frectonz.et/
• Docker Hub: https://hub.docker.com/r/frectonz/sql-studio