Data Toolkit for Developers

A VS Code extension built for data engineers. Convert lists, build SQL scripts, compare columns, count values, deduplicate data, and assemble Excel formulas — all without leaving your editor.

Features at a Glance

Context Menu (Right-Click) Commands

Select one or more lines in any editor, right-click, and choose Data Toolkit from the context menu.

Convert to CSV Format

Converts a multi-line selection into a properly formatted CSV row. Strips bullet points, numbers, and other list prefixes. Respects the delimiter setting.

Convert to Comma Separated Line

Converts a list into a single comma-separated line. Optionally wraps each value in single quotes — ready to paste into a SQL IN (...) clause.

Generate SQL Table from Selection

Select tabular data (tab- or comma-separated, with a header row) and generate a complete CREATE TABLE + INSERT script for the target SQL dialect.

Count Value Occurrences (GROUP BY)

Select a list of values and get a value,count CSV copied to your clipboard — sorted by frequency descending. Equivalent to SELECT value, COUNT(*) GROUP BY value ORDER BY 2 DESC.

Remove Duplicate Lines

Deduplicates the selected lines in-place, preserving the order of first occurrence.

Compare Two Columns

Opens the Data Toolkit panel on the Compare tab with Column A pre-filled from the current selection. Paste Column B to run set operations.

Data Toolkit Panel (Webview)

Open via the Command Palette (Ctrl+Shift+P → Data Toolkit: Open Toolkit) or the right-click menu.

Tab 1 — Convert

Paste a list into the input area and convert it with options:

• Remove duplicates before converting
• Output format: comma-separated line, CSV rows, or SQL IN clause
• Quote style: single or double quotes
• Delimiter: any character

The result is copied to your clipboard and shown in the preview area.

Tab 2 — Count & Dedupe

Paste a list to:

• Count values — get a sortable value,count table with a copy-to-clipboard button
• Remove duplicates — see the deduplicated list and copy it

Tab 3 — Compare Columns

Paste two lists (one per column) and choose a set operation:

Results are shown as a list and can be copied to the clipboard.

Tab 4 — SQL Builder

Paste tabular data (auto-detects tab, comma, pipe, or semicolon delimiters) and configure:

• Table name
• SQL dialect: Spark SQL, MS SQL Server, MySQL, PostgreSQL
• Infer data types: automatically detects INTEGER, DECIMAL, DATE, TIMESTAMP, VARCHAR

Generates a CREATE TABLE statement and INSERT rows. Copy the full script to your clipboard.

Example input:

id	name	hire_date	salary
1	Alice	2022-03-15	75000
2	Bob	2021-07-01	82000

Example output (PostgreSQL):

CREATE TABLE employees (
    id INTEGER,
    name VARCHAR(5),
    hire_date DATE,
    salary INTEGER
);

INSERT INTO employees (id, name, hire_date, salary) VALUES (1, 'Alice', '2022-03-15', 75000);
INSERT INTO employees (id, name, hire_date, salary) VALUES (2, 'Bob', '2021-07-01', 82000);

Tab 5 — Excel Formulas

Select a formula category, choose a formula, fill in the parameters, and copy the result. A live preview updates as you type.

Available formulas by category:

Settings

Open settings via Ctrl+Shift+P → Data Toolkit: Open Extension Settings.

Commands Reference

Requirements

No external dependencies. Works out of the box with VS Code 1.101.0 and later.

License

MIT