GitHub

Welcome to Database Management done right. SQLTools provides connections to many of the most commonly used databases, making it easier to work with your data. With this tool, developers will save (a lot of) time, increase productivity and feel like a database hero ✌️

SQLTools is an open-source project maintained by Matheus Teixeira and George James Software, alongside contributions from our brilliant community of users.

If you like using this tool please leave us a review.

Features

Connects to MySQL, PostgreSQL, Microsoft SQL Server and many more…

  • Beautifier and formatter for SQL code
  • Query runner, history and bookmarks
  • Connection explorer
  • Generator for INSERT queries
  • Pluggable driver architecture

Find out more in the documentation here.

Getting Started

SQLTools is a set of VS Code extensions that connect to, query, and display results from a SQL database manager. (Supported databases are listed below.)

The installation process is straightforward:

  • Open VS Code
  • Click the Extensions view (in the left bar), then search for @tag:sqltools-driver. This lists all the drivers available for SQLTools.
  • Install the driver for your database. This also installs the core SQLTools extension.
  • Click the SQLTools icon (in the left bar)
  • Create a connection to your database. To do this, hover over CONNECTIONS in the SQLTools pane. Click the β€œAdd New Connection” icon and choose the driver and enter the connection parameters.

You can then open and query it from within VS Code.

Supported Databases

To use SQLTools you will also need to install the appropriate driver extension for your database.

If the driver you want is not available, you can use our handy new drivers guide to write it yourself (and help our community in the process) or submit feedback via GitHub.

If you need a driver sooner, get in touch with the maintainers directly – we might be able to help you out.

Psst… we’re always on the lookout for maintainers for the official drivers, so let us know if this is something you’re interested in!

Official Drivers

DriverLinks
CockroachDBCockroachDBπŸ“š docs
⏬ marketplace
πŸ“¦ source
MariaDBMariaDBπŸ“š docs
⏬ marketplace
πŸ“¦ source
MSSQLMicrosoft SQL Server/AzureπŸ“š docs
⏬ marketplace
πŸ“¦ source
MySQLMySQLπŸ“š docs
⏬ marketplace
πŸ“¦ source
TiDBTiDBπŸ“š docs
⏬ marketplace
πŸ“¦ source
PostgreSQLPostgreSQLπŸ“š docs
⏬ marketplace
πŸ“¦ source
SQLiteSQLiteπŸ“š docs
⏬ marketplace
πŸ“¦ source

Community Drivers:

DriverLinks
AWS RedshiftAWS Redshift
by @kj-9
⏬ marketplace
πŸ“¦ source
ClickHouse logoClickHouse
by @ultram4rine
⏬ marketplace
πŸ“¦ source
Databricks logoDatabricks
by @Databricks
⏬ marketplace
πŸ“¦ source
DuckDB Sql ToolsDuckDB
by @RandomFractals
⏬ marketplace
πŸ“š docs
DuckDB Pro ToolsDuckDB Pro
by @RandomFractals
⏬ sign up
πŸ“š docs
DuckDB (Lastest Version Support) DuckDB (Latest Version)
by @Evidence
⏬ marketplace
πŸ“¦ source
Google BigQueryGoogle BigQuery
by @Evidence
⏬ marketplace
πŸ“¦ source
Google Cloud SpannerGoogle Cloud Spanner
by @cloudspannerecosystem
⏬ marketplace
πŸ“¦ source
Google Cloud SQL (PostgreSQL)Google Cloud SQL (PostgreSQL)
by @curioswitch
⏬ marketplace
πŸ“¦ source
HiveHive
by @datafe
⏬ marketplace
πŸ“¦ source
HologresHologres
by @datafe
⏬ marketplace
πŸ“¦ source
InterSystems IRIS logoInterSystems IRIS
by @daimor
⏬ marketplace
πŸ“¦ source
MaxComputeMaxCompute
by @datafe
⏬ marketplace
πŸ“¦ source
OracleOracle
by @hashhashu
⏬ marketplace
πŸ“¦ source
SAP HANASAP HANA
by @SAP
⏬ marketplace
πŸ“¦ source
SingleStoreSingleStore
by @SingleStore
⏬ marketplace
πŸ“¦ source
SnowflakeSnowflake
by @koszti
⏬ marketplace
πŸ“¦ source
SQLite Pro ToolsSQLite Pro
by @RandomFractals
⏬ sign up
πŸ“š docs
TeradataTeradata
by @ScriptPup
⏬ marketplace
πŸ“¦ source
TrinoTrino
by @regadas
⏬ marketplace
πŸ“¦ source
VerticaVertica
by @vertica
⏬ marketplace
πŸ“¦ source

Related Tools

NameLinks
Markdown SQL Pro ToolsMarkdown SQL Pro Tools
by @RandomFractals
⏬ sign up
πŸ“š docs
PRQL Pro ToolsPRQL Pro Tools
by @RandomFractals
⏬ sign up
πŸ“š docs

Contributing

We are grateful to our contributors for helping with this project ❀️ If you would like to join them you’ll find everything you need to know about contributing here.

Changelog

See the changelog here.

Feedback

Our aim is to build a tool that is genuinely helpful for developers. Therefore we welcome any feedback or additional feature requests – please submit them through the GitHub Issue system.

If you need help sooner, get in touch with the maintainers directly – we might be able to help you out.

About George James Software

George James Software has been providing innovative software solutions for over 35 years. We pride ourselves on the quality and maintainability of our code and we have built a number of tools to help developers achieve the same with their work. These are available as VS Code extensions here.

We also help other developers to build their own extensions. If there is a tool you need building please get in touch with us at info@georgejames.com.