Access Database Directly from VSCode

Posted on

Managing your database doesn’t have to mean switching back and forth between phpMyAdmin or DBeaver and your code editor. A powerful extension for Visual Studio Code, you can access database directly from VSCode — fast, simple, and efficient, it’s DevDB.

What is DevDB?

DevDB is a lightweight and underrated VSCode extension that brings database exploration and querying right into your editor. Think of it like an integrated SQL client — but built natively for developers who live in VSCode.

Key Features

  • Database Explorer – Browse databases, tables, columns, indexes, and more
  • SQL Query Editor – Write and run SQL queries, view results inline
  • Connection Manager – Add and manage multiple database connections
  • Supports Multiple DBs – Works with MySQL, PostgreSQL, SQLite, MSSQL, and more

How to Access XAMPP Database from DevDB

If you’re using XAMPP to run a local development environment (especially with MySQL or MariaDB), connecting DevDB is very straightforward.

Step-by-Step:

  • Make sure XAMPP is running, especially the MySQL service.
  • In VSCode, open the DevDB on the terminal panel area
  • Choose Laravel Mysql (with Sail support)
  • Click “Connect”.

Now you can browse tables, run queries, and inspect your local database without ever opening phpMyAdmin.