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.
Collecting all the cheat sheets
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.
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!
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
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.