.svg){kind=icon}
dbt™ is a SQL-first transformation workflow that lets teams quickly and collaboratively deploy analytics code following software engineering best practices like modularity, portability, CI/CD, and documentation. Now anyone on the data team can safely contribute to production-grade data pipelines.
Fast SQL for time-series
QuestDB is an open-source time-series database for high throughput ingestion and fast SQL queries with operational simplicity. It supports schema-agnostic ingestion using the InfluxDB line protocol, PostgreSQL wire protocol, and a REST API for bulk imports and exports.
Open-source low-code web application framework. Create full websites writing only simple database queries.
SQLpage is an SQL-only webapp builder. It is meant for data scientists, analysts, and business intelligence teams to build powerful data-centric applications quickly, without worrying about any of the traditional web programming languages and concepts.
With SQLPage, you write simple .sql files containing queries to your database to select, group, update, insert, and delete your data, and you get good-looking clean webpages displaying your data as text, lists, grids, plots, and forms.
Get MySQL EXPLAIN plans that are understandable for humans.
MySQL Query optimization with the EXPLAIN command is unnecessarily complicated: The output contains a lot of cryptic information that is incomprehensible or entirely misleading.
This Laravel package collects many query metrics that will be sent to explainmysql.com and transformed to be much easier to understand.
You no longer have to search for cryptic or incomprehensible information from MySQL query plans. All EXPLAIN outputs are transformed into data that is easier to grasp.
Collecting all the cheat sheets
Provides utilities for Postgres database schema versioning.
Pyrseas provides utilities to describe a PostgreSQL database schema as YAML, to verify the schema against the same or a different database and to generate SQL that will modify the schema to match the YAML description.
Random Data Generator and API Mocking Tool (JSON / CSV / SQL / Excel).
Need some mock data to test your app? Mockaroo lets you generate up to 1,000 rows of realistic test data in CSV, JSON, SQL, and Excel formats.
csvkit is a suite of command-line tools for converting to and working with CSV, the king of tabular file formats.
Pipelined Relational Query Language, pronounced "Prequel".
PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement. Like SQL, it's readable, explicit and declarative. Unlike SQL, it forms a logical pipeline of transformations, and supports abstractions such as variables and functions. It can be used with any database that uses SQL, since it compiles to SQL.
The SQL Editor and Database Manager Of Your Dreams.
A modern, easy to use, and good looking SQL client for MySQL, Postgres, SQLite, SQL Server, and more.
DuckDB is an in-process SQL OLAP database management system.
DuckDB is a high-performance analytical database system. It is designed to be fast, reliable, portable, and easy to use. DuckDB provides a rich SQL dialect, with support far beyond basic SQL
DuckDB supports arbitrary and nested correlated subqueries, window functions, collations, complex types (arrays, structs, maps), and several extensions designed to make SQL easier to use.
A truly Open Source MongoDB alternative.
FerretDB (previously MangoDB) was founded to become the de-facto open-source substitute to MongoDB. FerretDB is an open-source proxy, converting the MongoDB 6.0+ wire protocol queries to SQL - using PostgreSQL as a database engine.
In-Database Machine Learning.
MindsDB ML-SQL Server enables machine learning workflows for the most powerful databases and data warehouses using SQL.
Free multi-platform database tool for developers, database administrators, analysts and all people who need to work with databases. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, etc.
Migrate to PostgreSQL in a single command!
pgloader loads data into PostgreSQL and allows you to implement Continuous Migration from your current database to PostgreSQL. Read the White Paper to learn how to limit risks and control your budget, and start your PostgreSQL migration today!
NMIG is a database migration tool, written in Node.js and highly inspired by FromMySqlToPostgreSql.
NMIG is an app, intended to make a process of migration from MySQL to PostgreSQL as easy and smooth as possible.
Random Data Generator and API Mocking Tool | JSON / CSV / SQL / Excel.
Need some mock data to test your app? Mockaroo lets you generate up to 1,000 rows of realistic test data in CSV, JSON, SQL, and Excel formats.
Next-generation Node.js and TypeScript ORM for Databases.
Prisma helps app developers build faster and make fewer errors with an open source database toolkit for PostgreSQL, MySQL, SQL Server, and SQLite.
SQL Editor for Developers.
The SQL client and database
management tool that's fun to use