AtlasDB is a lightweight MySQL database explorer for Visual Studio Code.
It focuses on a practical MVP workflow: create secure MySQL connections, browse tables and views, inspect table structure, view and edit data, run SQL, and export results.
Features
MySQL connection manager from the Activity Bar.
Secure password storage using VS Code SecretStorage.
Database explorer with connections, databases, tables, views, fields, indexes and triggers.
Table data viewer with:
pagination
column sorting
basic SQL WHERE filtering
inline cell editing when the table has a primary key
CSV and JSON export
Basic SQL query editor.
Table structure viewer/editor for MySQL fields.
AtlasDB Output Channel with query timings and errors.
Requirements
VS Code compatible with the extension engine in package.json.
A reachable MySQL server.
A MySQL user with the permissions needed for the operations you run.
Basic Usage
Open the AtlasDB Activity Bar view.
Click Add Connection.
Fill in the MySQL connection form.
Save the connection.
Expand the connection and database.
Open Tables or Views.
Click a table to view data.
Use the table toolbar for pagination, sorting, filtering and export.
Use AtlasDB: New Query to open the SQL editor.
Current Limitations
MySQL is the only implemented driver in v0.1.0.
PostgreSQL and SQL Server are intentionally not supported yet.
Table data editing requires a primary key.
The WHERE filter accepts SQL text and relies on MySQL for validation.
Index and trigger editing is not implemented yet.
No SQL autocomplete yet.
Roadmap
Full index editor.
Full trigger editor.
Better column type picker.
PostgreSQL support.
SQL Server support.
Query history.
SQL autocomplete.
Safer migration previews for schema changes.
Security Notes
AtlasDB never stores passwords in globalState and never logs passwords. Passwords are stored with VS Code SecretStorage.
