OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.
Read more
Tag: sql
Turso – in-process SQL database
Turso is an in-process relational database engine designed to be compatible with SQLite. The project aims to evolve the SQLite architecture for modern applications by introducing a new implementation focused on performance, scalability, and distributed workloads. The database is intended
Read more
sql-pipe – read CSV via stdin, run SQL, emit CSV via stdout
sql-pipe is a command-line utility that lets you run SQL queries directly against CSV data streamed through standard input.
Read more
squix – manage and execute SQL queries across multiple databases
Squix is a minimal command-line database manager that allows users to manage connections and execute SQL queries across multiple databases.
Read more
GizmoSQL – high-performance SQL server
GizmoSQL is a powerful open-source SQL database engine and server powered by DuckDB and Apache Arrow Flight SQL.
Read more
sqlfmt – SQL formatter
sqlfmt formats your dbt SQL files. It is similar in nature to black, gofmt, and rustfmt (but for SQL).
Read more
SQLFluff – dialect-flexible SQL linter
SQLFluff is an open source, dialect-flexible and configurable SQL linter. It’s written in the Python language.
Read more
sqlit – lazygit of SQL databases
sqlit supports all major databases: SQL Server, PostgreSQL, MySQL, SQLite, MariaDB, FirebirdSQL, Oracle, DuckDB, CockroachDB, and more.
Read more
Harlequin – Terminal-based SQL IDE
Harlequin is an easy, fast, and beautiful database client for the terminal.
Read more
Conar – AI-powered tool to simplify database interactions
Store your connections securely in the cloud and ask AI to help you write and optimize SQL queries.
Read more
Musoq – SQL Swiss Army Knife
Stop writing throwaway scripts. Use SQL instead.
Read more
qo – query JSON, CSV, and TSV files using SQL
qo is a minimalist TUI that lets you query JSON, CSV, and TSV files using SQL.
Read more
ChartDB – web-based database diagramming editor
ChartDB is a powerful, web-based database diagramming editor. Instantly visualize your database schema with a single “Smart Query.”
Read more
data-peek – SQL client desktop application
Built for developers who want to quickly peek at their data without the bloat. Supports PostgreSQL, MySQL, and Microsoft SQL Server.
Read more
DoltgreSQL – Postgres-compatible version of Dolt
DoltgreSQL, or Doltgres for short, is a Postgres-compatible version of Dolt.
Read more
lazysql – cross-platform TUI database management tool
lazysql is a cross-platform TUI database management tool.
Read more
litecli – command-line client for SQLite databases
litecli is a command-line client for SQLite databases that has auto-completion and syntax highlighting.
Read more
PRQL – modern language for transforming data
PRQL is a modern language for transforming data – a simple, powerful, pipelined SQL replacement. It’s readable, explicit and declarative.
Read more
11 Best Free and Open Source Linux Data Science Notebook Software
A notebook interface is a virtual collaborative environment which contains computer code and rich text elements. Here’s the best free notebook software.
Read more
DB Browser for SQLite – create, design, and edit database files
DB Browser for SQLite (DB4S) is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.
Read more