A powerful VS Code extension for querying SQL and NoSQL databases using standard SQL syntax. Write SQL queries and execute them against various supported database engines — powered by SQLAlchemy.
Features
SQL Query Editor — A editor with SQL syntax highlighting
Connection Manager — Save, edit, and manage multiple database connections
SQL & NoSQL Databases — PostgreSQL, MySQL, SQLite, MongoDB, Snowflake, BigQuery, and many more
Result Viewer — View query results in an organized table or JSON format
Export Results — Export to CSV or JSON
Auto Driver Install — The required Python driver for each database is installed automatically on first use
Supported Databases
SQL4ALL supports any database that has a SQLAlchemy dialect — including PostgreSQL, MySQL, SQLite, Oracle, SQL Server, MongoDB, Snowflake, BigQuery, DuckDB, and many more.
See the full list of included and external dialects in the SQLAlchemy documentation.
Requirements
VS Code 1.110.0 or higher
Python 3.9 or higher
Note: On first activation, if no Python installation is detected, SQL4ALL will prompt you to select a Python executable. You can also configure it at any time via the status bar or the command SQL4ALL: Select Python Executable.
Python Dependencies
The extension automatically installs the required Python packages:
sqlalchemy >= 2.0 — core query engine
A database-specific driver — installed automatically on first connection
Installation
Open VS Code
Go to Extensions (Ctrl+Shift+X / Cmd+Shift+X)
Search for SQL4ALL
Click Install
Quick Start
Add a Connection — Click the + button in the SQL4ALL sidebar
Select Database Type — Pick from the supported list and fill in credentials
Open SQL Executor — Click the ▶ button on a connection to list its tables and open the editor
Write & Run — Enter a SQL query, then press Ctrl+Enter or click Run
View Results — Results appear in the table below the editor
Export — Click Export CSV or Export JSON to save results
Known Issues
Very large result sets (>100K rows) may impact performance
Some databases require additional system-level dependencies (e.g., ODBC drivers for SQL Server)
SQL4ALL
