The smoothest, best looking, and easiest to use SQL client for MySQL, Postgres, SQLite, SQL Server, Red shift, MariaDB, CockroachDB and more.

Beekeeper Studio - Open Source SQL Editor and Database Manager

MikroORM is a TypeScript ORM for Node.js based on Data Mapper, Unit of work and Identity Map patterns. It supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases. Heavily inspired by Doctrine and Nextras ORM.
 
It allows handling transactions automatically. When you call em.flush() all computed changes are wrapped inside a database transaction. It uses source code analysis so you do not have to repeat yourself when defining entities. Simply define correct TypeScript types and you are good to go.
 
Its features include:
<ul>
<li>Clean and Simple Entity Definition</li>
<li>Identity Map</li>
<li>Entity References</li>
<li>Using Entity Constructors</li>
<li>Modelling Relationships</li>
<li>Collections</li>
<li>Unit of Work</li>
<li>Transactions</li>
<li>Cascading persist and remove</li>
<li>Composite and Foreign Keys as Primary Key</li>
<li>Filters</li>
<li>Using QueryBuilder</li>
<li>Preloading Deeply Nested Structures via populate</li>
<li>Property Validation</li>
<li>Lifecycle Hooks</li>
<li>Vanilla JS Support</li>
<li>Schema Generator</li>
<li>Entity Generator</li>
</ul>

MikroORM is a TypeScript ORM for Node.js based on Data Mapper, Unit of work and Identity Map patterns. It supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases. Heavily inspired by Doctrine and Nextras ORM.

MikroORM - TypeScript ORM for Node

DbGate is cross-platform database manager. It's designed to be simple to use and effective, when working with more databases simultaneously. But there are also many advanced features like schema compare, visual query designer, chart visualisation or batch export and import. It supports MySQL, PostgreSQL ,SQL Server, MongoDB, Redis, SQLite, Amazon Redshift, CockroachDB, and MariaDB.
 
Its features include: 
<ul>
<li>Table data editing, with SQL change script preview</li>
<li>Edit table schema, indexes, primary and foreign keys</li>
<li>Compare and synchronize database structure</li>
<li>ER diagram</li>
<li>Light and dark theme</li>
<li>Master/detail views, foreign key lookups</li>
<li>Query designer</li>
<li>Form view for comfortable work with tables with many columns</li>
<li>JSON view on MongoDB collections</li>
<li>Explore tables, views, procedures, functions, MongoDB collections</li>
<li>SQL editor
<ul dir="auto">
<li>execute SQL script</li>
<li>SQL code formatter</li>
<li>SQL code completion</li>
<li>Add SQL LEFT/INNER/RIGHT join utility</li>
</ul>
</li>
<li>Mongo JavaScript editor, execute Mongo script (with NodeJs syntax)</li>
<li>Redis tree view, generate script from keys, run Redis script</li>
<li>Runs as application for Windows, Linux and Mac. Or in Docker container on server and in web Browser on client.</li>
<li>Import, export from/to CSV, Excel, JSON, XML</li>
<li>Free table editor - quick table data editing (cleanup data after import/before export, prototype tables etc.)</li>
<li>Archives - backup your data in JSON files on local filesystem (or on DbGate server, when using web application)</li>
<li>Charts, export chart to HTML page</li>
<li>For detailed info, how to run DbGate in docker container, visit <a href="https://hub.docker.com/r/dbgate/dbgate" rel="nofollow">docker hub</a></li>
<li>Extensible plugin architecture</li>
<li>Perspectives - nested table view over complex relational data</li>
</ul>

DbGate is cross-platform database manager. It's designed to be simple to use and effective, when working with more databases simultaneously. But there are also many advanced features like schema compare, visual query designer, chart visualisation or batch export and import. It supports MySQL, PostgreSQL ,SQL Server, MongoDB, Redis, SQLite, Amazon Redshift, CockroachDB, and  MariaDB.

DbGate- Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others

TypeORM is an ORM that can run in NodeJS, Browser, Cordova, PhoneGap and Ionic platforms and can be used with TypeScript and JavaScript (ES5, ES6, ES7). Its goal to always support latest JavaScript features and provide features that help you to develop any kind of applications that use databases - from small applications with a few tables to large scale enterprise applications with multiple databases.
 
TypeORM supports both Active Record and Data Mapper patterns, unlike all other JavaScript ORMs currently exist, which means you can write high quality, loosely coupled, scalable, maintainable applications the most productive way.

TypeORM is an ORM that can run in NodeJS, Browser, Cordova, PhoneGap and Ionic platforms and can be used with TypeScript and JavaScript (ES5, ES6, ES7). Its goal to always support latest JavaScript features and provide features that help you to develop any kind of applications that use databases - from small applications with a few tables to large scale enterprise applications with multiple databases.

Typeorm - Amazing ORM for TypeScript and JavaScript (ES7, ES6, ES5)

Objection.js is an ORM for Node.js that aims to stay out of your way and make it as easy as possible to use the full power of SQL and the underlying database engine while keeping magic to a minimum.Objection.js is built on an SQL query builder called knex. All databases supported by knex are supported by objection.js. SQLite3, Postgres and MySQL are thoroughly tested.

Objection.js - An SQL-friendly ORM for Node.js

Bookshelf is a JavaScript ORM for Node.js, built on the Knex SQL query builder. Featuring both promise based and traditional callback interfaces, providing transaction support, eager/nested-eager relation loading, polymorphic associations, and support for one-to-one, one-to-many, and many-to-many relations. It is designed to work well with PostgreSQL, MySQL, and SQLite3.
 
Bookshelf aims to provide a simple library for common tasks when querying databases in JavaScript, and forming relations between these objects, taking a lot of ideas from the the Data Mapper Pattern.

 Bookshelf is a JavaScript ORM for Node.js, built on the Knex SQL query builder. Featuring both promise based and traditional callback interfaces, providing transaction support, eager/nested-eager relation loading, polymorphic associations, and support for one-to-one, one-to-many, and many-to-many relations. It is designed to work well with PostgreSQL, MySQL, and SQLite3.

Bookshelf - A simple Node.js ORM for PostgreSQL, MySQL and SQLite3 built on top of Knex.js

usql is a universal command-line interface for PostgreSQL, MySQL, Oracle, SQLite3, Microsoft SQL Server, and other databases.The below is a demonstration using usql with xo's booktest simple test database, showcasing the release version v0.5.0. In the demonstration, usql connects to a PostgreSQL database, executes some queries, with variable interpolation, connects to a SQLite3 database file, and does some more queries, before then connecting to a Microsoft SQL database and ending the session.

usql - universal command-line interface for SQL databases

Cube.js is an open-source analytical API platform. It is primarily used to build internal business intelligence tools or add customer-facing analytics to existing applications. Cube.js was designed to work with serverless data warehouses and query engines like Google BigQuery and AWS Athena. A multi-stage querying approach makes it suitable for handling trillions of data points. Most modern RDBMS work with Cube.js as well and can be further tuned for performance.

Cube.js — Open-Source Analytical API Platform

Database agnostic SQL exporter for Prometheus. SQL Exporter is a configuration driven exporter that exposes metrics gathered from DBMSs, for use by the Prometheus monitoring system. Out of the box, it provides support for MySQL, PostgreSQL, Microsoft SQL Server and Clickhouse, but any DBMS for which a Go driver is available may be monitored after rebuilding the binary with the DBMS driver included.

sql_exporter - Database agnostic SQL exporter for Prometheus

MLCraft is an open-source low-code business intelligence tool and a data science workflow. MLCraft was designed to query the data from several data warehouses and run machine learning experiments. Cube.js is used as a primary query layer and makes it suitable for handling trillions of data points. It is a full-stack data science platform that provides everything you need to build, manage and automate machine learning 

MLCraft - Low-code business intelligence tool and a data science workflow

Discover open source projects across all platforms

Projects