# Database Clients & IDEs

> Query and manage SQL, NoSQL, and analytical databases.

Navigation: [Index](../../llms.txt) · [HTML](https://awesomeopensource.dev/topic/database-clients)

Database clients and IDEs provide a graphical interface for writing queries, browsing schemas, and inspecting results. This topic covers desktop apps and web-based tools for relational, document, and analytical databases.

Use this comparison to find a client with the right database drivers, keyboard workflow, diagramming, and team-sharing features.

## Feature comparison

| Project | Multiple database engines | SQL editor | SSH tunneling | Import and export | Schema diagrams | Web-based interface | NoSQL engine support |
|---|---|---|---|---|---|---|---|
| [dbeaver/dbeaver](../dbeaver-dbeaver.md) | – | – | – | – | – | No | Partial (NoSQL databases require the commercial editions.) |
| [beekeeper-studio/beekeeper-studio](../beekeeper-studio-beekeeper-studio.md) | – | – | – | – | – | No | Partial (Redis is in the community edition; MongoDB and other engines need a paid edition.) |
| [TabularisDB/tabularis](../tabularisdb-tabularis.md) | Yes | Yes | Yes | Yes | Yes | No | No |
| [Syngnat/GoNavi](../syngnat-gonavi.md) | Yes | Yes | Yes | Yes | – | Yes | Yes |
| [ShayanAbbas1/dbdelve](../shayanabbas1-dbdelve.md) | Yes | Yes | – | – | – | No | Yes |
| [albertoarena/laravel-truss](../albertoarena-laravel-truss.md) | Yes | Yes | No | Yes | Yes | Yes | No |
| [dbgate/dbgate](../dbgate-dbgate.md) | Yes | Yes | No | Yes | Yes | Yes | Yes |
| [frectonz/sql-studio](../frectonz-sql-studio.md) | Yes | Yes | – | – | – | Yes | No |
| [gridex/gridex](../gridex-gridex.md) | Yes | Yes | Yes | Yes | Yes | No | Yes |
| [dhanikk/dbstan](../dhanikk-dbstan.md) | Yes | No | No | Yes | No | Yes | No |
| [sqlectron/sqlectron](../sqlectron-sqlectron.md) | Yes | Yes | – | – | – | No | No |
| [appbaseio/dejavu](../appbaseio-dejavu.md) | – | – | – | – | – | Yes | Yes |
| [garraflavatra/rolens](../garraflavatra-rolens.md) | No | No | – | Yes | No | No | Yes |
| [next-build/database-viewer](../next-build-database-viewer.md) | No | No | No | No | No | Yes | No |
| [officert/mongotron](../officert-mongotron.md) | No | No | No | – | – | No | Yes |
| [daniel-werner/laravel-schemacrawler](../daniel-werner-laravel-schemacrawler.md) | No | Yes | No | Yes | Yes | No | No |
| [mrvautin/adminMongo](../mrvautin-adminmongo.md) | Yes | Yes | No | Yes | No | Yes | Yes |

## Features

- **Multiple database engines**: Connects to several engines such as PostgreSQL, MySQL, MongoDB or Redis.
- **SQL editor**: Provides a query editor with syntax help.
- **SSH tunneling**: Connects through an SSH tunnel.
- **Import and export**: Imports or exports data and dumps.
- **Schema diagrams**: Visualizes tables or entity relationships.
- **Web-based interface**: Runs in a browser as a hosted or self-hosted web application.
- **NoSQL engine support**: Connects to document, key-value or search engines such as MongoDB, Redis or Elasticsearch.

## 17 projects

- [dbeaver/dbeaver](../dbeaver-dbeaver.md) · Activity score 5.0/5 (Thriving)
- [beekeeper-studio/beekeeper-studio](../beekeeper-studio-beekeeper-studio.md) · Activity score 5.0/5 (Thriving)
- [TabularisDB/tabularis](../tabularisdb-tabularis.md) · Activity score 5.0/5 (Thriving)
- [Syngnat/GoNavi](../syngnat-gonavi.md) · Activity score 5.0/5 (Thriving)
- [ShayanAbbas1/dbdelve](../shayanabbas1-dbdelve.md) · Activity score 5.0/5 (Thriving)
- [albertoarena/laravel-truss](../albertoarena-laravel-truss.md) · Activity score 5.0/5 (Thriving)
- [dbgate/dbgate](../dbgate-dbgate.md) · Activity score 4.9/5 (Thriving)
- [frectonz/sql-studio](../frectonz-sql-studio.md) · Activity score 4.9/5 (Thriving)
- [gridex/gridex](../gridex-gridex.md) · Activity score 4.5/5 (Thriving)
- [dhanikk/dbstan](../dhanikk-dbstan.md) · Activity score 2.7/5 (Maintained)
- [sqlectron/sqlectron](../sqlectron-sqlectron.md) · Activity score 2.5/5 (Maintained)
- [appbaseio/dejavu](../appbaseio-dejavu.md) · Activity score 1.9/5 (Slowing down)
- [garraflavatra/rolens](../garraflavatra-rolens.md) · Activity score 1.3/5 (Abandoned)
- [next-build/database-viewer](../next-build-database-viewer.md) · Activity score 1.3/5 (Abandoned)
- [officert/mongotron](../officert-mongotron.md) · Activity score 1.2/5 (Abandoned)
- [daniel-werner/laravel-schemacrawler](../daniel-werner-laravel-schemacrawler.md) · Activity score 1.1/5 (Abandoned)
- [mrvautin/adminMongo](../mrvautin-adminmongo.md) · Activity score 1.0/5 (Abandoned)
