DevDb is a VS Code extension designed to streamline database development and debugging by providing direct database access and manipulation within the IDE. It targets developers working with various databases, offering a zero-configuration approach for common setups and a flexible configuration file for others, ultimately reducing context switching and improving developer experience.

How It Works

DevDb auto-loads databases using connection details from VS Code workspace configurations (e.g., Laravel's .env) or a project-level .devdbrc file. It presents database tables and data directly within VS Code, allowing for in-line editing, row deletion, and null value setting. Key features include SQL query explanation via MySQL Visual Explain and intelligent factory class generation for Laravel Eloquent models.

Quick Start & Requirements

• Install: Via VS Code Extensions Marketplace.
• Prerequisites: VS Code 1.83+, supported database accessible from the project.
• Setup: Zero-config for common Laravel setups; manual .devdbrc creation otherwise.
• Docs: [Not explicitly linked, but functionality is described in README]

Highlighted Details

• Zero-config support for Laravel with SQLite, MySQL, MariaDB, PostgreSQL, and Microsoft SQL Server.
• In-editor data editing with undo/redo and save functionality.
• MySQL query explanation via Code Lens or context menu.
• Laravel Eloquent model integration for table viewing and factory generation.
• Supports SQLite, MySQL, MariaDB, PostgreSQL (with ongoing development for full features), and Microsoft SQL Server.

Maintenance & Community

• Contributions are currently limited to extension core code; UI code is not open for contribution.
• [No community links like Discord/Slack or social handles provided in the README.]

Licensing & Compatibility

• License: Not specified in the README.
• Compatibility: Designed for VS Code; commercial use implications are unclear due to unspecified licensing.

Limitations & Caveats

VS Code multi-root workspace support is under development. Contributions to the UI code are not currently accepted. PostgreSQL support for certain table column indicators and SQL display is still in development.