Open files in VS Code and Cursor / Tables and data

Use a MySQL client in VS Code

Install the free Postgres & MySQL Query Client by Zovo. It connects to MySQL and MariaDB, and to PostgreSQL and SQLite. Add a connection with a mysql:// URL, open a .sql file and press Ctrl+Enter (Cmd+Enter on macOS). Editing rows is free. Before anything is saved you see the exact SQL, and it runs in one transaction.

Free, MIT license. Extension ID zovo.zovo-sql-client, version 0.2.4. Needs VS Code 1.90.0 or newer.

Also free from Zovo: SQLite Editor & Viewer, VS Code Marketplace · Open VSX (Cursor, Windsurf).

Steps in VS Code

1. Install Postgres & MySQL Query Client from the Marketplace, or press Ctrl+P (Cmd+P on macOS) and run ext install zovo.zovo-sql-client.
2. Open the SQL Client view in the activity bar and click Add Connection.
3. Paste a URL such as mysql://me@localhost:3306/shop, or fill in the form. Click Test connection, then Save.
4. Click New Query, type SQL and press Ctrl+Enter. Each result gets its own tab, and an error underlines the right place in your SQL.
5. Click a table to browse it. Use + Row, Delete or a double-click on a cell, then Review and save.

Steps in Cursor, Windsurf or VSCodium

1. Open the Extensions view with Ctrl+Shift+X (Cmd+Shift+X on macOS).
2. Search for zovo.zovo-sql-client and click Install. Cursor, Windsurf and VSCodium install from Open VSX, where it is published as zovo/zovo-sql-client.
3. If your editor has no gallery, download the .vsix from the Open VSX page and run "Extensions: Install from VSIX...".
4. Then use it the same way as in VS Code.

What Postgres & MySQL Query Client handles

• MySQL and MariaDB through the mysql2 driver, PostgreSQL through pg, and SQLite files.
• Autocomplete for your tables, views, columns and aliases, plus the keywords of each dialect.
• Row edits for any table with a primary key. Each statement must change exactly one row, or nothing is saved.
• Cancel stops a running query on the server with KILL QUERY. In the release test a 60-second query stopped 0.13 seconds after the click.
• Copy results as CSV, JSON, Markdown or tab-separated text. Export to CSV, JSON or SQL INSERT with no row limit.
• Clear messages for a wrong password, a refused connection or a server that needs SSL. A server that does not answer gives up after 10 seconds instead of hanging.

What it does not do

• No SQL Server, Oracle, Redis or MongoDB.
• No visual query builder.
• One result keeps up to 100,000 rows in the grid (a setting). Exports have no limit.
• The ER diagram, schema compare, CSV import and query library are Zovo Pro tools, with 3 free tries each.

In JetBrains IDEs (IntelliJ IDEA, PyCharm, WebStorm, CLion and others)

• Database Tools and SQL. JetBrains' own database tools, in DataGrip and IntelliJ IDEA Ultimate. They connect to PostgreSQL and MySQL, run SQL and edit table data. For WebStorm they come as this plugin (1,090,402 downloads). Zovo has no JetBrains database plugin.
• Database Navigator. A free plugin with 5,052,374 downloads. Its listing calls it "a database development and management plugin for JetBrains IDEs".

Other options

• MySQL (cweijan.vscode-mysql-client2, 3 million installs, on Open VSX). Its own description: "Database Management for MySQL/MariaDB, PostgreSQL, Redis and ElasticSearch." The most installed MySQL client for VS Code.
• DBCode (DBCode.dbcode, 231,684 installs, on Open VSX). Its own description: "SQL & database client for Postgres, MySQL, SQL Server, SQLite, MongoDB, Oracle and 100+ more, in VS Code, Cursor and Windsurf." Pick it if you need SQL Server, Oracle or MongoDB.
• SQLTools (mtxr.sqltools, 7.2 million installs, on Open VSX). Its own description: "Connecting users to many of the most commonly used databases." Each database needs its own driver extension.
• MySQL Workbench. The free desktop tool for MySQL from Oracle.

Install counts and Open VSX status were checked on 9 November 2026. Descriptions in quotes are the extensions' own.

Questions

More about Postgres & MySQL Query Client

Read the Postgres & MySQL Query Client page for every feature and setting, or the source code on GitHub.

Related guides

• SQLite Editor & Viewer on the VS Code Marketplace (also on Open VSX). Opens .db and .sqlite files as tables, edits cells and runs SQL.
• Use a PostgreSQL client in VS Code
• See an ER diagram of your database in VS Code
• Compare two Postgres schemas
• See a Postgres EXPLAIN plan as a tree in VS Code