This is the third edition focusing on VScode extensions (originally shared on LinkedIn). This time, we will review five supporting extensions for working with tabular data and databases in VScode.
Next week's focus is on supporting extensions for working with Python on VScode.
I share daily updates on Substack, Facebook, Telegram, WhatsApp, and Viber.
Data Wrangler
The Data Wrangler is a new extension from Microsoft, that provides a UI to view and analyze tabular data in VScode. Currently, it supports Pandas DataFrame objects and CSV files.
Downloads: 1M
Unique Identifier: ms-toolsai.datawrangler
Marketplace: link
Rainbow CSV
The Rainbow CSV extensions add color highlighting for your CSV (e.g., comma, semicolon, and pipe-separated) file columns. In addition, the extension enables you to query and filter the data using SQL (alike) syntax.
Downloads: 13M
Unique Identifier: mechatroner.rainbow-csv
Marketplace: link
Snowflake
The Snowflake extension from Snowflake, provides a set of tools to connect and work with a Snowflake database from VScode. This includes SQL Intellisense, the ability to query data, view the data, and view available schema and tables.
Downloads: 0.2M
Unique Identifier: snowflake.snowflake-vsc
Marketplace: link
PostgreSQL
The PostgreSQL extension provides tools for querying data from PostgreSQL databases. It provides a database explorer and language services.
Downloads: 1M
Unique Identifier: ckolkman.vscode-postgres
Marketplace: link
SQLTools
The SQLTools extension provides tools to connect and work with a variety of databases from VScode. This includes language support for SQL, connection widgets, and pluggable driver architecture.
Downloads: 5M
Unique Identifier: mtxr.sqltools
Marketplace: link
Are there any other recommendations for extensions for working with data in VScode?
See you next week!
Rami