Databases

Database Visualization

Connect a database and LakshX draws it — tables, collections, and the relationships between them — as an ER diagram, right inside the IDE. It works across four engines.

Status bar$(database) DBCommandLakshX: Show Database Panel

Supported engines

  • PostgreSQL, MySQL, SQLite — relational schemas with real foreign keys, drawn as solid relationship edges.
  • MongoDB — collections with relationships inferred from your documents.

Opening the panel

Two ways in:

  • Click DB in the status bar (the database icon).
  • Run LakshX: Show Database Panel from the command palette.

Connecting

  • SQLite — pick the database file with an open dialog; it opens read-only.
  • PostgreSQL / MySQL / MongoDB — paste a connection string into a masked input, validated against the engine’s scheme.

Credentials are stored in the IDE’s per-extension secret storage — never in a file in your repo. To switch databases, use Change Connection… in the panel, or run LakshX: Forget Database Credentials to clear them.

Reading the diagram

The panel’s Schema tab renders your database as an entity-relationship diagram, so you can see structure and joins at a glance instead of piecing them together from migration files.

Browsing real rows — the Data tab

Switch to the Data tab to browse actual rows yourself: pick a table/collection from the dropdown and page through its contents directly, with client-side column sorting. This is you looking at your own data — it works whether or not Allow AI queriesis on, and it’s unrelated to the agent.

Data tab vs. Allow AI queries — two different things

The Datatab has no query box — there’s nowhere to type a question here. “Allow AI queries” is a separate opt-in that lets the coding agent (in the chat panel) read rows while it works, in response to something you ask it in plain language — see db_query. Turning that toggle on doesn’t add anything to this panel; it changes what the agent is allowed to do elsewhere.