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.
 
Its feature include: 
<ul dir="auto">
<li>Create and compact database files</li>
<li>Create, define, modify and delete tables</li>
<li>Create, define, and delete indexes</li>
<li>Browse, edit, add, and delete records</li>
<li>Search records</li>
<li>Import and export records as text</li>
<li>Import and export tables from/to CSV files</li>
<li>Import and export databases from/to SQL dump files</li>
<li>Issue SQL queries and inspect the results</li>
<li>Examine a log of all SQL commands issued by the application</li>
<li>Plot simple graphs based on table or query data</li>
</ul>

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.

SQLiteBrowser- DB Browser for SQLite (DB4S) project

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

Database Subsetting and Browsing Tool. Exports consistent, referentially intact row-sets from relational databases (JDBC). Removes data w/o violating integrity. Generates DbUnit datasets, hierarchically structured XML and topologically sorted SQL-DML. 
<ul>
<li>Exports consistent and referentially intact row-sets from your productive database
and imports the data into your development and test environment.</li>
<li>Improves database performance by removing and archiving obsolete data without violating integrity.</li>
<li>Generates topologically sorted SQL-DML, hierarchically structured XML and DbUnit datasets.</li>
<li>Data Browsing. Navigate bidirectionally through the database by following foreign-key-based or user-defined relationships.</li>
<li>SQL Console with code completion, syntax highlighting and database metadata visualization.</li>
</ul>

Database Subsetting and Browsing Tool. Exports consistent, referentially intact row-sets from relational databases (JDBC). Removes data w/o violating integrity. Generates DbUnit datasets, hierarchically structured XML and topologically sorted SQL-DML.

Jailer - Database Subsetting and Browsing Tool

DB Lens is an open-source database client that helps you to explore database, understand data relations more quickly with automatic ER diagrams, visualise and analyse internal DB metrics such as index utilisation sequential scans, slow running queries, storage and many more.

DB Lens - Database explorer for Mac, Windows & Linux

Discover open source projects across all platforms

Projects

SQLiteBrowser- DB Browser for SQLite (DB4S) project

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

Jailer - Database Subsetting and Browsing Tool

DB Lens - Database explorer for Mac, Windows & Linux

TechStack

Tagcloud

License

Suggested keywords:

Projects

SQLiteBrowser- DB Browser for SQLite (DB4S) project

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

Jailer - Database Subsetting and Browsing Tool

DB Lens - Database explorer for Mac, Windows & Linux

TechStack

Tagcloud

License