DbGate - Free Self-hosted Database Manager for Serious Database Developers, and Admins

DbGate is free and open-source fast and easy to use database manager. It works seamlessly with MySQL, PostgreSQL, SQL Server, and several other database engines.

DbGate is getting regular update and it is an ideal solution for database admins, web developers, devOps, and of course data engineers.

14 Open-source Web-based SQL Database Managers

SQL stands for Structured Query Language, and it is a standardized language used to manage relational databases. It is used to create, modify, and query databases, and is commonly used in web development and data analysis. SQL allows users to manage large amounts of data, and to interact with that

MEDevel.com: Open-source for Healthcare, and EducationHazem Abbas

Features

• 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, NDJSON, XML
• Archives - backup your data in NDJSON files on local filesystem (or on DbGate server, when using web application)
• NDJSON data viewer and editor - browse NDJSON data, edit data and structure directly on NDJSON files. Works also for big NDSON files
• 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, query designer on MongoDB databases
• JSON Log messages

23 Flat File Database Open-source, JavaScript, Rust, Python, Java, PHP, and Go

What is a Flat File Database? Flat-file databases, well, they’re a kind of database that keep data in a plain text file, right? Every line of that text file holds a record, with fields split by delimiters, like commas or tabs. Some of them don’t have the fancy relational structure

MEDevel.com: Open-source for Healthcare, and EducationHazem Abbas

Supported Databases

• MySQL
• PostgreSQL
• SQL Server
• Oracle
• MongoDB
• Redis
• SQLite
• Amazon Redshift (Premium)
• CockroachDB
• MariaDB
• CosmosDB (Premium)
• ClickHouse

Platforms

• Windows
• Linux
• macOS
• ARM (Windows, Linux, macOS)

License

GPL-3.0 License

Resources & Downloads

• Github
• Code
• Home

GitHub - janproch/dbgate-svelte: Database manager for MySQL, PostgreSQL and SQL Server. Runs under Windows, Linux, Mac or as web application

Database manager for MySQL, PostgreSQL and SQL Server. Runs under Windows, Linux, Mac or as web application - janproch/dbgate-svelte

GitHubjanproch

GitHub - dbgate/dbgate: Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application

Database manager for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite and others. Runs under Windows, Linux, Mac or as web application - dbgate/dbgate

GitHubdbgate

DbGate | Open Source SQL+noSQL Database Client

Powerful cross-platform SQL client and database manager for MySQL, SQL Server, Oracle, PostgreSQL, SQLite, MongoDB, Redis. Fast, modern and 100% free.

Open Source SQL+noSQL Database Client