SQL Studio: A Universal SQL Database Explorer Built with Rust
This repository profile is provided by osrepos.com, an open source repository discovery platform.
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 Information
Topics
Click on any tag to explore related repositories
Use at your own risk
OSRepos shares public repositories for knowledge and discovery only. Any installation, execution, configuration, or use of code from these repositories is the user's own responsibility. Always review the repository, source code, dependencies, licenses, and security implications before running or installing anything. OSRepos is not responsible for issues, damages, or losses resulting from third-party 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:
- 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
Related repositories
Similar repositories that may be relevant next.
CubeSandbox: Instant, Concurrent, and Secure Sandbox for AI Agents
August 9, 2026
CubeSandbox, developed by TencentCloud, is a high-performance, secure sandbox service built on RustVMM and KVM, designed specifically for AI agents. It offers ultra-fast startup times, hardware-level isolation, and high-density deployment, making it ideal for scalable and secure agent execution environments. The service is also fully compatible with the E2B SDK for seamless integration.
StringWars: Benchmarking High-Performance String Processing in Rust and Python
July 21, 2026
StringWars is a comprehensive GitHub repository dedicated to benchmarking performance-oriented string processing libraries in Rust and Python. It meticulously compares various operations, including substring search, hashing, and edit distances, across both CPUs and GPUs. This project serves as an invaluable resource for developers seeking to identify the fastest and most efficient solutions for critical string manipulation tasks, particularly those leveraging modern SIMD instructions and GPU acceleration.
pgrust: Postgres Rewritten in Rust, Passing All Regression Tests
July 11, 2026
pgrust is an ambitious project rewriting Postgres in Rust, now successfully passing 100% of Postgres regression tests. It aims for compatibility with Postgres 18.3 and offers significant performance improvements, especially for transaction and analytical workloads. This project focuses on making internal changes easier while maintaining Postgres behavior and disk compatibility.
OpenLogi: A Native, Local-First Logitech Options+ Alternative in Rust
June 1, 2026
OpenLogi is a native, local-first alternative to Logitech Options+, built with Rust. It allows users to remap mouse buttons, control DPI, and manage SmartShift functionality over HID++ without requiring an account or collecting telemetry. This project prioritizes privacy and local control for Logitech mouse users.
Source repository
Open the original repository on GitHub.
12 counted GitHub visits