Sqlit – 一款类似于 lazygit 的 SQL 数据库 TUI(文本用户界面)

2作者: MaxTeabag大约 1 个月前原帖
sqlit 是一个类似 lazygit 的 SQL TUI(文本用户界面)。您可以在几秒钟内从终端连接并查询数据库,无需先阅读配置文件或文档。 它支持所有主要数据库:SQL Server、PostgreSQL、MySQL、SQLite、MariaDB、FirebirdSQL、Oracle、DuckDB、CockroachDB、ClickHouse、Snowflake、Databricks、Supabase、Cloudflare D1、Turso、Athena、BigQuery、Spanner、Redshift、IBM Db2、SAP HANA、Teradata、Trino、Presto、Apache Flight SQL、Apache Impala、SurrealDB 和 osquery。 内置的一些功能包括: - 键盘聚焦:上下文感知的快捷键绑定始终可见 - Docker 集成:自动检测并连接到正在运行的数据库容器 - Vim 风格的查询编辑器,支持自定义快捷键绑定 - 结果窗口中的模糊过滤 - SSH 隧道、操作系统密钥环凭证存储、密码管理器集成 - 表、列和过程的自动补全 - 云 CLI 集成(通过 Azure / AWS / GCP CLI 浏览外部数据库) - 主题(Rose Pine、Tokyo Night、Nord、Gruvbox) 安装:`pipx install sqlit-tui`(也支持 `uv tool install` 和 `pip`)。 该工具使用 Python 和 Textual 开发。首次分享于去年十二月(https://news.ycombinator.com/item?id=46276002),自那以来有很多新功能发布。 代码库: https://github.com/Maxteabag/sqlit 欢迎反馈,尤其是关于日常使用中仍缺少的功能。 我的目标是制作一个美观的工具,使连接和查询数据变得简单而愉快,并真正专注于做好这一件事。
查看原文
sqlit is a lazygit-style TUI for SQL. Connect and query your database from the terminal in seconds, no config files or documentation to read first.<p>It supports all the major databases: SQL Server, PostgreSQL, MySQL, SQLite, MariaDB, FirebirdSQL, Oracle, DuckDB, CockroachDB, ClickHouse, Snowflake, Databricks, Supabase, Cloudflare D1, Turso, Athena, BigQuery, Spanner, Redshift, IBM Db2, SAP HANA, Teradata, Trino, Presto, Apache Flight SQL, Apache Impala, SurrealDB, and osquery.<p>A few things that come built in:<p>- Keyboard focus: Context aware keybindings always visible<p>- Docker integration: auto-detects and connect to running database containers<p>- Vim-style query editor with customizable keybindings.<p>- Fuzzy filter in results window.<p>- SSH tunnels, OS-keyring credential storage, password manager integration.<p>- Autocomplete for tables, columns, and procedures.<p>- Cloud CLI integration (browse external DBs via Azure &#x2F; AWS &#x2F; GCP CLIs).<p>- Themes (Rose Pine, Tokyo Night, Nord, Gruvbox).<p>Install: `pipx install sqlit-tui` (also works with `uv tool install` and `pip`).<p>Built with Python and Textual. First shared here in December (https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=46276002) - a lot has shipped since.<p>Repo: https:&#x2F;&#x2F;github.com&#x2F;Maxteabag&#x2F;sqlit<p>Feedback welcome, especially on what&#x27;s still missing for daily-driver use.<p>My goal is to make an aesthetic tool that makes it easy and enjoyable to connect and query data, and do that one thing only, really well.