One of the main reasons to try our #DuckDBPro 🛠️ in @code IDE are the 30+ custom #DuckDB view & metadata shortcut commands you can invoke from the standard VS Code Commands Palette while exploring those embedded DB files in your apps for your next EDA #dataProject ...

📰 https://github.com/RandomFractals/pro-data-tools/blob/main/duckdb-tools.md#duckdb-view-commands

#ProDataTools 🧙‍♂️ ...

Gonna roll up our sleeves and add new remote url and local data file #DuckDB connection mapping magic and data loading to the #DuckDBPro Tools this month.

#ProDataTools 🛠️ 🧙‍♂️ ...

Our combined #ProDataTools 🛠️ changelog, covering prominent features and enhancements added to #DuckDB SQL and #DuckDBPro Tools, #PRQLCodeLens and new #MarkdownSQLPro Tools in 15 releases of the new #DataTools for VS Code ID published this year so far:

🧐 https://randomfractals.github.io/pro-data-tools/CHANGELOG

Using #MarkdownSQLPro Tools 🛠️ with new #SQLBookmarks 🔖, #SQLite & our #DuckDBPro #SQLTools in #VSCode IDE on @ploomber's #JupySQL #JupyText / #MyST #JupyterBook 📓 markdown docs 😎

#SQL #DuckDB #Markdown #ProDataTools 🧙‍♂️ ...

All of our #ProDataTools 🛠️ are just $2.66 today with GitHub's prorated sponsorship tier pricing.

💖 https://github.com/sponsors/RandomFractals/sponsorships?tier_id=295482

Sign up today to get #DuckDBPro Tools, #PRQLProTools and our latest #MarkdownSQLProTools to query DuckDB and other data sources with #SQLTools in VS Code IDE like a Pro. More to come soon!

You can sponsor our work on GitHub to get access to the new #MarkdownSQL and other #ProDataTools 🛠️ like #DuckDBPro.

You will get notified when new SQL code lenses for R markdown, Quarto and Observable markdown documents are released. Only $4 today:

💖 ⤑ https://github.com/sponsors/RandomFractals/sponsorships?tier_id=295482

The next monthly release of #DuckDBPro Tools 🛠️ will integrate with VS Code File Explorer to load CSV, JSON and parquet data files from local file system, remote workspaces, public end-points, and S3 buckets.

It will streamline creating new #DuckDB instances to load, explore, and query data using #SQLTools in VS Code.

Sign up to get notified when this feature will be released:

💖 + 💸 = 🛠️ ⤑ https://github.com/sponsors/RandomFractals

More info about our #ProDataTools 🛠️ for VS Code IDE:

📰 ⤑ https://github.com/RandomFractals/pro-data-tools

Quick demo of the new Extract All SQL and Execute SQL code lenses in the upcoming #MarkdownSQL Pro Tools v1.2.0 with #JupyterBook markdown support and #JupySQL / #SQLMagics SQL code extraction and execution in action:

This example uses VS Code #SQLTools and #DuckDBPro Tools to execute SQL queries directly from the Jupy SQL Jupyter Book markdown document (https://github.com/ploomber/jupysql/blob/master/doc/quick-start.md).

#VSCode #ProDataTools 🧙‍♂️ ...

With #MarkdownSQLProTools v1.1.0 we plan to release to our sponsors on GitHub this week, you'll be able to run SQL code from code blocks in markdown documents and plain SQL documents & use different #SQLTools drivers, #DuckDBPro in this demo ... #ProDataTools 🧙‍♂️ ...

🧐 https://randomfractals.github.io/pro-data-tools/#markdown-sql-pro-tools

📰 Great news for all the #DuckDBPro's & fans of our #DataTools 🛠️ out there:

Today we released #DuckDBProTools v1.3.0 with #DuckDB v0.8.0 support.

See updated docs & examples below & become a #ProTools sponsor on GitHub to access the latest and greatest in #ProDataTools for #VSCode.

💖 ⤑ https://github.com/sponsors/RandomFractals

Took #StarCoder from #BigCodeProject for a spin today. Used 🤗 #VSCode autocomplete extension to generate a bunch of sample employees #DuckDB SQL queries for the next #DuckDBPro Tools update. #DataTools 🔬 ...

https://www.linkedin.com/feed/update/urn:li:activity:7060961253258625024/

A lot of work went into making #DuckDBPro Tools. So, we hope it's a fair game to post some info about it in @duckdb discussions for those interested in better #DuckDB tooling in VSCode IDE. Cheers! #DataTools 🧐

https://github.com/duckdb/duckdb/discussions/7388

Quick View #DuckDB schemata shortcut command demo. More such metadata function and view shortcut commands will be added in the next #DuckDBPro Tools update. #DataTools 🔬 ...

Yup! You can install and load #DuckDB #geoSpatial extension in our #DuckDBPro Tools too. It just needs installed status and description update. See: https://github.com/duckdblabs/duckdb_spatial #GeoDataTools 🗺️ ...

Creating Pro Tools with examples takes time and good book-keeping habits. Snapshot of the #DuckDBPro Tools private beta changelog we released back in March. #DataTools 🧙‍♂️ ...
Our Pro sponsors on github can access it directly: https://github.com/RandomFractals/duckdb-pro-tools/blob/main/CHANGELOG.md

Enhanced SQL IntelliSense in the upcoming #DuckDBPro #SQLTools v1.1.0 with active #DuckDB connection tables and column name hints, and database and schema name displayed in those @code tips as you type SQL. #DataTools 🧙‍♂️ ...

Refined #DuckDB table columns display in #DuckDBPro Tools v1.1.0 we plan to release later this week. Note added primary 🔑/ column type iconography, db type and not null constraint display in the column tree view node detail. #VSCode #SQLTools / #DataTools 🧙‍♂️ ...

Also, for the DuckDB @code fans out there, we just added Indexes display to our #DuckDBPro Tools ... DuckDB Pro Sql Tools FTW coming to @code terminals near you soon! 😎 #SQL / #DataTools 💎💎💎

Quick preview of the upcoming #DuckDBPro Tools v1.1.0 with extended DB objects tree view display showing #DuckDB instance databases, schemas, tables, views, installed and loaded DuckDB extensions, DB types, functions, and keywords. #DataTools 🛠️ #VSCode 🧙‍♂️ ...

Extended DuckDB objects display in #DuckDBPro Tools is shaping up nicely. New DB objects tree view with finer icons and a list of databases, schemas, tables, views and settings with setting data type and current value displayed for #DuckDB config view at a glance. #DataTools 🧙‍♂️...