Tools/Maxteabag/sqlit

sqlit

A user-friendly TUI for SQL databases. Supports SQL Server, MySQL, PostgreSQL, SQLite, and more.

4.8k+14/wkemergingPythonMIT Licensetrending

The Lens

By Erik Loyd, SaaS CEO and former COO/CFO of an AWS Premier Partner.

Updated Aug 2026

sqlit is a database client that runs in your terminal. Connect to SQL Server, MySQL, Postgres, SQLite, or Turso, browse tables, run queries, and read results in a formatted grid, all from the keyboard. No browser, no Electron shell, no login. MIT licensed and written in Python.

Install is a pip command and you are connected. One unified interface across every backend it supports is the actual selling point, because moving between a Postgres project and a SQL Server project stops meaning moving between tools. It is under active development, with releases landing steadily through 2026.

Completely free, with no paid tier and no hosted version. Solo: excellent for quick checks without waiting for a heavy GUI to load. Small teams: good for developers who live in the terminal and want data in front of them fast. Medium and large: this is a personal productivity tool rather than a team platform, so shared database management still wants dbeaver/dbeaver or something web-based with access control.

The catch is that it is early and thin next to the mature tools. No saved queries, no ER diagrams, no export wizards. It is a browser, not a workbench. It will not replace DataGrip or DBeaver for schema work, but for the twenty times a day you just need to look at a table, it opens instantly and gets out of the way.

Free vs Self-Hosted vs Paid

fully free

Free tier: Everything. MIT licensed, installed with pip, no account and no license key. Every supported backend is available in the free package.

Self-hosted: There is nothing to host. sqlit runs on your machine and connects directly to whatever databases you already have. The one operational note is credentials: you are handing a local TUI your database connection strings, so treat its config the way you treat any other file holding production passwords.

Paid: No paid tier exists. The commercial comparison is DataGrip at around $99 a year for individuals or a TablePlus license, both of which buy you schema tooling, saved queries, and export wizards that sqlit does not have.

Free under MIT with nothing gated. The paid tools cost money because they do schema work sqlit does not attempt.

What to do by team size

Solo
free; the fastest way to glance at a table
Small team
free; good fit for terminal-first developers
Medium team
free, but shared database management wants DBeaver or a web tool
Large team
free; a personal utility, not a team platform
Self-hosting ops:trivial

Get tools like this every Wednesday

One featured tool, three on the radar. No fluff.

Similar Tools

Score
72/100 · B+
Adoption17/30
Maintenance21/25
Community9/20
License15/15
Analysis10/10

A low score is not a verdict on quality. Young and niche tools start low by design. How we calculate scores

Trust Signals

Growing adoption: 4,037 starsPermissive license (MIT)

About

Stars
4,846
Forks
164

Explore Further

More tools in the directory

Featured in The Open Source Drop #1