AtlasDB

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.
• Server-level connections that discover all databases accessible to the MySQL user.
• Secure password storage using VS Code SecretStorage.
• Database explorer with connections, databases, tables, views, fields, indexes, relationships 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
• SQL query editor with:
  • schema-aware completion for SQL keywords, tables and columns
  • execution of the selected SQL or the full editor with Ctrl/Cmd+Enter
  • multiple result-set tabs
  • configurable result limits
  • query cancellation
  • EXPLAIN for SELECT and WITH queries
  • CSV and JSON result export
  • persistent history and named favorites
• Table structure viewer/editor for MySQL fields, indexes and foreign-key relationships.
• Visual table creator with primary keys, storage engine selection and SQL preview.
• Interactive ER diagram with relationship-aware layout, cardinality markers, PK/FK columns, draggable and collapsible tables, neighbor highlighting, fit-to-screen, zoom, pan, filtering and saved positions.
• 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

1. Open the AtlasDB Activity Bar view.
2. Click Add Connection.
3. Fill in the MySQL connection form. Leave Database name empty to browse every database the user can access, or enter one to open it directly.
4. Save the connection.
5. Expand the connection and database.
6. Open Tables or Views.
7. Click a table to view data.
8. Use the table toolbar for pagination, sorting, filtering and export.
9. Use AtlasDB: New Query to open the SQL editor. Run with the button or Ctrl/Cmd+Enter; select part of the SQL to execute only that selection.
10. Use a database's context menu to create a table, and a table's structure view to manage fields and indexes.
11. Use Open ER Diagram from a database to explore its relationships visually.

Current Limitations

• MySQL is the only implemented driver in v0.4.1.
• 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.
• Trigger editing is not implemented yet.
• Query cancellation closes the active MySQL connection; transactions running in that editor connection are rolled back by MySQL.

Roadmap

• Full trigger editor.
• Better column type picker.
• PostgreSQL support.
• SQL Server support.
• Safer migration previews for schema changes.

Development

• npm run compile validates types, lint rules and the development bundle.
• npm test runs the VS Code integration test suite.
• npm run package builds the production bundle.

Security Notes

AtlasDB never stores passwords in globalState and never logs passwords. Passwords are stored with VS Code SecretStorage.