Database Light

A database client for Visual Studio Code. Browse servers, run SQL, edit rows and manage schemas without leaving the editor.

Supported

MySQL and MariaDB, PostgreSQL, SQL Server, SQLite, Exasol.

What it does

• Paste a connection URL (postgres://…, mysql://…) and the form fills itself in
• A server tree with databases, tables, views, procedures, functions and triggers
• A SQL editor with completion, formatting and inline run buttons
• A result grid that edits, filters, sorts and exports rows
• Structure diff between two databases
• Import and export: SQL dumps, CSV, JSON, Excel
• Mock data generation
• SSH tunnels for connections that are not exposed publicly

Settings

Every setting lives under the database-light. namespace — search for "Database Light" in the settings UI.

Install

Search for Database Light in the Extensions view, or:

code --install-extension muhammadalive.database-light

To work on it, press F5 in this repository — webpack watches the sources and you only reload the window.

License

MIT — see LICENSE. Forked from vscode-database-client by Weijan Chen.