A lightweight VS Code extension that auto-loads your database. It provides a beautiful database GUI client experience, bringing Convention over Configuration into database management.
Built with 💖 for developers.
DevDb can automatically load your database using connection details from your VS Code workspace (zero-config mode). When zero-config support is not available for your development environment, configuration file option is available. These two options are explained below:
1. Zero-config (automatic database loading)
No configuration file is needed for these environments:
2. Config-based database loading
If there is no zero-config support for your environment, simply provide a
The content of the configuration file should be a single array containing database connection objects as shown below:
SQLite database configuration file example
MySQL/MariaDB database configuration file example
Postgres database configuration file example
You can also have more than one connections in the configuration file, e.g.
The following databases are currently supported:
Language and Framework Integrations
Context Menu entry
You can load a table by right-clicking on its name/model/entity from the editor (framework/programming language-agnostic) Example from a Node JS app (a Sequelize model definition)
Laravel model Code Lens
If working in a Laravel project, DevDb provides Code Lens for viewing Eloquent model underlying table. NOTE: You need to first connect to a database in DevDb for Laravel Code Lens to be available.
Two words: Better DX.
DevDb aims to be a DB GUI client specifically designed for a much better development experience when working with databases. Specifically, these experiences:
Local DX should be better than this.
Also, most of the DB clients are clunky or simply overwhelming, with bells and whistles that are not really useful during local development flow. Usually, being able to simply view DB data is all that is needed during local development.
Furthermore, who doesn't love beautiful UIs? DB clients have evolved to generally not have exciting UIs in my opinion, except just a few with excellent and intuitive UIs.
To address the above, there is a need for a database GUI tool that lives in the IDE, and mostly auto-detects and connects with the database configured in the currently opened workspace. It should be simple, fast, intuitive, and clean.
Hence, DevDb 🚀
DevDb does not aim to provide feature-parity with popular GUI database clients. This extension is focused on improving the experience of working with databases during application development.