Database Manager (Beta) 🚀

A lightweight database management extension for VS Code that allows developers to connect, browse, inspect, and manage databases directly inside the editor.

⚠️ Beta Release
This extension is currently under active development. Features may change and bugs may exist.

Database Manager is built for developers who want to manage databases without leaving their coding environment.

---

Features

Current features available:

• Connect to database servers directly from VS Code
• Browse databases and schemas through sidebar explorer
• Explore tables dynamically
• Open table data inside VS Code
• Interactive table viewer for inspecting records
• SQL query execution support
• Database metadata exploration without leaving the editor

---

Supported Databases

Database Manager is currently focused on delivering a stable and reliable PostgreSQL experience inside VS Code.

Currently Supported:

• PostgreSQL ✅

Upcoming Support:

• MySQL 🚧
• MongoDB 🚧
• Redis 🚧
• SQLite 🚧
• More database engines coming soon.

The current development focus is building a robust PostgreSQL foundation before expanding support to other database systems.

---

Quick Start 🚀

Get started with Database Manager in a few simple steps.

1. Open Command Palette

Open the VS Code command palette:

Ctrl + Shift + P   (Windows/Linux)
Cmd + Shift + P    (macOS)

---

2. Connect to Database

Run the command:

Database Manager: Connect

Enter your database connection details:

• Host
• Port
• Username
• Password

Example:

Host: localhost
Port: 5432
Username: postgres
Password: ********

---

3. Browse Databases

After connecting successfully, the extension sidebar will display all available databases.

Example:

localhost:5432
 ├ postgres
 ├ my_database
 └ analytics

Expand the server to explore databases, schemas, and tables.

---

4. Explore Tables

Navigate through the database structure:

Database → Schema → Tables

Example:

my_database
 └ public
    └ Tables
       ├ users
       ├ orders
       └ products

---

5. Open Table Viewer

Click any table to open the built-in table viewer.

Available features:

• View records in grid format
• Browse table data directly inside VS Code
• Inspect database content without leaving the editor

---

6. Execute SQL Queries

Run SQL queries directly from the extension.

Supported operations:

• SELECT
• INSERT
• UPDATE
• DELETE
• DDL / DML Queries

Example:

SELECT * FROM users;

UPDATE users
SET name = 'Alex'
WHERE id = 1;

---

7. Refresh Connection

Refresh server metadata anytime.

Options:

• Right-click server → Refresh Server
• Or run:

Database Manager: Refresh Server

---

Troubleshooting 🛠️

Database not appearing

Check the following:

• Database server is running
• Host and port are correct
• Credentials are valid

Reconnect using:

Database Manager: Connect

---

Connection failed

Verify:

• PostgreSQL server is accessible
• Firewall is not blocking the connection
• Username and password are correct

---

Tables not loading

Possible reasons:

• Database permissions are insufficient
• Schema access is restricted
• Connection was interrupted

Try refreshing the connection.

---

Extension not responding

If the extension behaves unexpectedly:

• Reload VS Code
• Reconnect to database
• Restart database server

---

Roadmap

Upcoming improvements planned:

• Multi-database support
• Table editing and row updates
• Insert and delete records
• SQL query editor improvements
• Multiple saved connections
• Query history
• Export data (CSV / JSON)
• Database migration tools
• Performance optimizations

---

Known Issues

Current beta limitations:

• PostgreSQL support only
• UI and commands may change during development
• Large table performance improvements are still in progress
• Some advanced SQL operations are under development

If you encounter bugs, please report them.

---

Release Notes

v0.0.15-beta

Initial beta release.

Implemented:

• PostgreSQL connection support
• Database explorer sidebar
• Schema and table navigation
• Table data viewer
• Basic SQL execution support

---

Built With

• TypeScript
• VS Code Extension API
• PostgreSQL Driver (pg)

---

License

MIT License

---

Feedback

This extension is actively being developed.

Feature requests, bug reports, and feedback are always welcome.

---

Built with ❤️ for developers who live inside VS Code.