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.
AgentAleph: Local-First AI Coding Agent and GGUF Model Manager
September 25, 2026
AgentAleph is a desktop application that combines a local-first AI coding agent with a GGUF model manager. It allows users to download, load, and manage local large language models, and then use an AI agent to interact with their projects, all without relying on cloud services or API keys. This tool emphasizes privacy and offline capability, running models directly on your machine.
browser-rs-mcp: Lightweight Stealth Browser Server for AI Agents in Rust
September 25, 2026
browser-rs-mcp is a lightweight, stealth-oriented Model Context Protocol (MCP) browser server written in Rust. It enables multiple AI agents to share a single, persistent Chrome instance, offering over 64 Playwright-style tools without requiring a Node.js runtime. This project is ideal for parallel web scraping, automation, and QA, providing efficient and isolated tab control for each agent.
LLM Wiki: Build a Self-Maintaining, Interlinked Knowledge Base with AI
September 23, 2026
LLM Wiki is a powerful cross-platform desktop application designed to transform your documents into an organized, interlinked knowledge base automatically. Unlike traditional RAG systems, it incrementally builds and maintains a persistent wiki from your sources, ensuring knowledge is compiled once and kept current. This innovative approach offers a dynamic and evolving personal knowledge management solution.
Coven: Local-First Runtime for AI Coding Agent Sessions
September 18, 2026
Coven is a powerful local-first runtime designed for managing project-scoped AI coding agent sessions. It provides durable state, robust authority boundaries, and seamless interoperability with multiple coding harnesses like Codex, Claude Code, and GitHub Copilot CLI. This tool enables developers to safely launch, observe, and coordinate AI agent work directly within their local project environments.
Source repository
Open the original repository on GitHub.
20 counted GitHub visits