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

  •        2936

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:

  • Table data editing, with SQL change script preview
  • Edit table schema, indexes, primary and foreign keys
  • Compare and synchronize database structure
  • ER diagram
  • Light and dark theme
  • Master/detail views, foreign key lookups
  • Query designer
  • Form view for comfortable work with tables with many columns
  • JSON view on MongoDB collections
  • Explore tables, views, procedures, functions, MongoDB collections
  • SQL editor
    • execute SQL script
    • SQL code formatter
    • SQL code completion
    • Add SQL LEFT/INNER/RIGHT join utility
  • Mongo JavaScript editor, execute Mongo script (with NodeJs syntax)
  • Redis tree view, generate script from keys, run Redis script
  • Runs as application for Windows, Linux and Mac. Or in Docker container on server and in web Browser on client.
  • Import, export from/to CSV, Excel, JSON, XML
  • Free table editor - quick table data editing (cleanup data after import/before export, prototype tables etc.)
  • Archives - backup your data in JSON files on local filesystem (or on DbGate server, when using web application)
  • Charts, export chart to HTML page
  • For detailed info, how to run DbGate in docker container, visit docker hub
  • Extensible plugin architecture
  • Perspectives - nested table view over complex relational data

https://dbgate.org
https://github.com/dbgate/dbgate

Tags
Implementation
License
Platform

   




Related Projects

Beekeeper Studio - Open Source SQL Editor and Database Manager

  •    Javascript

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

Prisma - Next-generation ORM for Node.js and TypeScript

  •    Typescript

Prisma helps app developers build faster and make fewer errors with an open source ORM for PostgreSQL, MySQL and SQLite. It makes database access easy with an auto-generated and type-safe query builder that's tailored to your database schema. It provides an alternative to traditional ORMs and SQL query builders.

DBeaver - Universal SQL Manager and SQL Client

  •    Java

DBeaver is a multi-platform database tool for developers, SQL programmers, database administrators and analysts. It supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc. Its feature include metadata editor, SQL editor, rich data editor, ERD, data export/import/migration, SQL execution plans, etc.

Mongify - Data translator system for moving your SQL data to MongoDB

  •    Ruby

Mongify allows you to map your data from a sql database and into a mongodb document database. It supports MySQL, PostgreSQL, SQLite, Oracle, SQLServer, and DB2.

dbeaver - Free universal database tool and SQL client

  •    Java

Free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports any database which has JDBC driver (which basically means - ANY database). EE version also supports non-JDBC datasources (WMI, MongoDB, Cassandra, Redis). You can download prebuilt binaries from official web site or directly from GitHub releases.


Coolstorage - ORM library for .NET

  •    CSharp

The main strength of Vici CoolStorage is the ease of use. Most ORM tools still require a lot of unneeded code to accomplish basic data persistence tasks, but Vici CoolStorage is designed to relieve the programmer from these tedious and error-prone tasks, making it very intuitive to use.

sql_exporter - Database agnostic SQL exporter for Prometheus

  •    Go

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.

OmniDB - Web tool for database management

  •    Python

OmniDB is a browser-based tool that simplifies database management focusing on interactivity, designed to be powerful and lightweight. It supports Tree view showing database structure, Powerful table creation, Syntax highlighting for SQL, SQL code completion for table columns and subquery, Graphs displaying complete ER diagram, Visualization of explain plan and lot more.

phpMyFAQ - phpMyFAQ - Open Source FAQ system for PHP and MySQL, PostgreSQL and other databases

  •    PHP

phpMyFAQ is a multilingual, completely database-driven FAQ-system. It supports various databases to store all data, PHP 5.6+ is needed in order to access this data. phpMyFAQ also offers a multi-language Content Management System with a WYSIWYG editor and an Image Manager, real time search support with Elasticsearch, flexible multi-user support with user and group based permissions on categories and records, a wiki-like revision feature, a news system, user-tracking, 40+ supported languages, enhanced automatic content negotiation, HTML5/CSS3 based responsive templates, PDF-support, a backup-system, a dynamic sitemap, related FAQs, tagging, RSS feeds, built-in spam protection systems, OpenLDAP and Microsoft Active Directory support, and an easy to use installation script. phpMyFAQ is only supported on PHP 5.6.0 and up, you need a database as well. Supported databases are MySQL, Percona Server, PostgreSQL, Microsoft SQL Server, SQLite3 and MariaDB. If you want to use Elasticsearch as main search engine, you need Elasticsearch 2.x as well. Check our detailed requirements on phpmyfaq.de for more information.

PostGIS - Spatial and Geographic objects for PostgreSQL

  •    C

PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL. PostGIS adds extra types (geometry, geography, raster and others) to the PostgreSQL database. It also adds functions, operators, and index enhancements that apply to these spatial types.

usql - universal command-line interface for SQL databases

  •    Go

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.

pgAdmin - Administration and development platform for PostgreSQL

  •    C

pgAdmin is the most popular and feature rich administration and development platform for PostgreSQL. It is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. The application also includes a syntax highlighting SQL editor, a server-side code editor, an SQL/batch/shell job scheduling agent, support for the Slony-I replication engine and much more.

Aura.SqlQuery - Independent query builders for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server.

  •    PHP

Provides query builders for MySQL, Postgres, SQLite, and Microsoft SQL Server. These builders are independent of any particular database connection library, although PDO in general is recommended. This package is installable and PSR-4 autoloadable via Composer as aura/sqlquery.

SQLx - The Rust SQL Toolkit

  •    Rust

SQLx is an async, pure Rust SQL crate featuring compile-time checked queries without a DSL. It is truly Asynchronous. Built from the ground-up using async/await for maximum concurrency. It has support for PostgreSQL, MySQL, SQLite, and MSSQL.

SQLToNoSQLImporter - Import data from SQL to NoSQL systems

  •    Java

SQLToNoSQLImporter is a Solr like data import handler to import Sql (MySQL,Oracle,PostgreSQL) data to NoSQL Systems (Mongodb,CouchDB,Elastic Search). Migration is now completely configuration driven. SQLToNoSQLImporter reads from sql databases, converts and then batch inserts them into NoSQL datastore.

SQLiteBrowser- DB Browser for SQLite (DB4S) project

  •    C++

DB Browser for SQLite (DB4S) is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite. It is for users and developers wanting to create databases, search, and edit data. It uses a familiar spreadsheet-like interface, and you don't need to learn complicated SQL commands.

php-crud-api - Single file PHP script that adds a REST API to a SQL database

  •    PHP

Single file PHP 7 script that adds a REST API to a MySQL 5.6 InnoDB database. PostgreSQL 9.1 and MS SQL Server 2012 are fully supported. NB: This is the TreeQL reference implementation in PHP.

CloudBeaver - Cloud Database Manager

  •    Java

CloudBeaver is a free and open source web-based database management tool. It currently supports multiple databases: MariaDB, PestgreSQL, SQLite, Firebird, MySQL. It allows to manipulate with data like in a regular spreadsheet. It has complete features of all database management tools like Execute SQL queries, Navigate and observe database structure: schemas, tables, views indexes, View properties of database objects etc.

An Un-sql SQL Database Installer

  •    CSharp

D.E.M.O.N SQL Database Installer is an Un-SQL(SQL means boring here) Database server installer for many types of Database :MySQL, FireBird, SQLite and others.

JavaScript SQL (JSSQL)

  •    Javascript

A database engine entirely in JavaScript (AJAX)






We have large collection of open source products. Follow the tags from Tag Cloud >>


Open source products are scattered around the web. Please provide information about the open source projects you own / you use. Add Projects.