sql
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.
Related contents:
- DuckDB - Le moteur SQL qui transforme vos données @ Korben :fr:.
- Why DuckDB is my first choice for data processing @ >robinlinacre.
- DuckDB is Probably the Most Important Geospatial Software of the Last Decade @ dbreunig.com.
- Why Semantic Layers Matter — and How to Build One with DuckDB @ MotherDuck.
- Querying Billions of GitHub Events Using Modal and DuckDB (Part 1: Ingesting Data) @ noreasontopanic.
- DuckDB beats Polars for 1TB of data @ Confessions of a Data Guy.
- Building Your Modern Data Analytics Stack with Python, Parquet, and DuckDB @ KD nuggets.
- Building an Obsidian RAG with DuckDB and MotherDuck @ MotherDuck.
- DuckDB Internals: Why is DuckDB Fast? (Part 1) @ Greybeam.
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.
Related contents:
- Microsoft builds open source document database on PostgreSQL, suggests FerretDB as front end @ The Register.
- Building for Developers—Not Imitators @ MongoDB.
- Oxygen Deprivation: FerretDB with Peter Farkas @ Contributor.fyi.
- FerretDB Was Eating My CPU: Migrating Komodo from SQLite to Postgres @ mauveRANT.
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.
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.
Related contents:
SQL Editor for Developers. The SQL client and database management tool that's fun to use
It's a tool that's used for performing queries on streams of records in various formats.
The goal is to make ad-hoc exploration of data sets easy without having to use more heavy-weight tools like SQL/MapReduce/custom programs. rq fills a similar niche as tools like awk or sed, but works with structured (record) data instead of text.
It was created with love out of the best parts of Rust, C and Javascript, and is distributed as a dependency-free binary on many operating systems and architectures.
Open source analytics toolbox
Analyze your data without writing a line of SQL.
automatic SQL injection and database takeover tool.
SQLmap is an open source penetration testing tool that automates the process of detecting and exploiting SQL injection flaws and taking over of database servers.
Allows you to easily execute SQL against structured text like CSV or TSV.
SchemaSpy is a Java-based tool (requires Java 5 or higher) that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships as represented by both HTML links and entity-relationship diagrams. It's also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints.
sqlcake is an automatic SQL injection exploitation kit written in Ruby. It's designed for system administration and penetration testing.
SQuirreL SQL is an open-source Java SQL Client program for any JDBC compliant database