Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

SQL Database Explorer [SQLite, libSQL, PostgreSQL, MySQL/MariaDB, ClickHouse, DuckDB, Microsoft SQL Server]

License

NotificationsYou must be signed in to change notification settings

frectonz/sql-studio

Repository files navigation

banner

SQL Studio

Single binary, single command SQL database explorer. SQL studio supportsSQLite,libSQL,PostgreSQL,MySQL,DuckDB andMicrosoft SQL Server.

Local SQLite DB File

sql-studio sqlite [sqlite_db]

Remote libSQL Server

sql-studio libsql [url] [auth_token]

Local SQLite DB with libSQL driver

sql-studio local-libsql [database]

PostgreSQL Server

sql-studio postgres [url]

MySQL/MariaDB Server

sql-studio mysql [url]

Local DuckDB File

sql-studio duckdb [duckdb_file]

ClickHouse Server (Partial Support)

sql-studio clickhouse [URL] [USER] [PASSWORD] [DATABASE]

Microsoft SQL Server

sql-studio mssql [connection]

Features

  • Overview page with common metadata.
  • Tables page with each table's metadata.
  • Queries page with more access to your db.
  • Infinite scroll rows view.
  • Rich SQL IntelliSense for custom queries.

More features available on thereleases page.

Screenshots

Overview Page

overviewoverview dark

Tables Page

tablestables dark

Query Page

queryquery dark

Installation

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.46/sql-studio-installer.sh| sh

Install prebuilt binaries via powershell script

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

Updating

sql-studio-update

Nix

nix shell nixpkgs#sql-studio

Docker

A Docker image of SQL Studio is available onDocker Hub. The following is an example of how to run SQL Studio with the Postgres driver on port3030.

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/

Contributing

Before executingcargo run you need to build the UI because the rust app statically embedded the UI files in the binary.

git clone git@github.com:frectonz/sql-studio.gitcd sql-studionix develop# if you use nixcd uinpm installnpm run buildcd ..cargo run

About

SQL Database Explorer [SQLite, libSQL, PostgreSQL, MySQL/MariaDB, ClickHouse, DuckDB, Microsoft SQL Server]

Topics

Resources

License

Stars

Watchers

Forks

Sponsor this project

 
[8]ページ先頭
©2009-2025 Movatter.jp