Skip to content

Pro Data Tools πŸ› οΈ for VS Code IDE πŸ§™β€β™‚οΈ: DuckDB Pro Tools, PRQL Code Lens, new Markdown SQL Pro Tools, upcoming Data Notebooks πŸ“š Pro Tools docs and demos, etc.

Notifications You must be signed in to change notification settings

RandomFractals/pro-data-tools

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

Random Fractals Inc. Data Tools

Random Fractals Inc. Data Tools πŸ› οΈ is a collection of public data visualization extensions, data viewers, VS Code Notebook renderers, and code snippets for devs and data scientists using VS Code IDE, published under our Random Fractals Inc. β˜‚οΈ org.

Random Fractals Data Tools

Pro Data Tools

Pro Data Tools is our new Premium set of SQL and PRQL Code Lenses and Data Viewers created for our monthly Pro sponsors on GitHub to enhance SQL development and SQL statements execution runtime workflow in VS Code IDE, connected to the different database management systems via SQL Tools extension, database plugins, and SQL Tools drivers.

Pro Data Tools

SQLite Pro Tools VS Code Extension Info

DuckDB Pro Tools

Our Pro Data Tools πŸ› οΈ include DuckDB Pro Tools extension that adds advanced DuckDB connection features and support to VSCode IDE, and provides database schemas display, DuckDB extensions and settings views, information schema and catalog views, SQL query API and user interfaces integrated with the popular SQL Tools extension, SQL query editor, SQL language server, and VS Code data processing tools.

DuckDB Pro Tools Views

You can read more about the free and public DuckDB SQL Tools Preview VS Code extension and new Premium DuckDB Pro Tools extension capabilites and features in our new DuckDB Tools documentation page.

SQLite Pro Tools

Pro Data Tools VS Code extensions also include SQLite Pro Tools. SQLite Pro Tools provide over a dozen of common SQLite database shortcut Commands, display table column data type and primary key indicators, SQLite database Indexes, Modules, Configuration Settings and Functions.

SQLite Pro Tools Views

PRQL Pro Tools

Our Pro sponsors on GitHub also get access to the Premium PRQL Pro Tools VS Code extension. PRQL Pro Tools extension comes with a custom PRQL Code Lens SQL Tools plugin that allows you to run PRQL queries for the supported PRQL target SQL dialects directly using any of the supported SQL Tools extension drivers for the different database management systems.

PRQL Pro Tools Code Lens

Markdown SQL Pro Tools

Markdown SQL Pro Tools extension adds custom SQL Code Lenses to SQL code blocks in standard SQL and various markdown documents in VS Code IDE.

The provided SQL Code Lenses include top-level SQL and markdown document Execute All, Select All, Extract All, Bookmark All SQL code lenses, Execute, Select, and Copy SQL code block lenses, and Create New SQL document from SQL code block lens.

Our SQL Code Lenses integrate with the popular SQL Tools Connections manager, supported SQL Tools drivers, and query results viewer to execute SQL directly on any of the supported SQL Tools database management systems and view results.

Markdown SQL Pro Tools

Markdodown SQL Pro Tools extension is available under the new Markdown Sql Pro Tools monthly sponsor subscription on GitHub and also includes access to the DuckDB Pro SQL Tools plugin and PRQL Code Lens extension from our Premium Pro Data Tools extensions pack.

Data Notebook Pro Tools

The new Data Notebook Pro Tools extension from our Premium Pro Data Tools extensions pack will be released later this year for our Pro sponsors on GitHub.

Data Notebook Pro extension integrates SQL Tools connections, supported database management systems, our Data Table Renderers and VS Code Jupyter Notebook user interface to view and run SQL queries from .sql files and .md markdown documents with SQL code blocks using native VS Code Notebook View.

Data Notebook Extension

Data Notebook SQL Query

Simple example of running SQL query with the new Data Notebook Pro Tools extension:

Data Notebook SQL Query

Data Notebook Output Rendering

Using different Data Table Renderers in the Data Notebook created from SQL document with multiple SQL queries:

Data Notebook Output Rendering

Future Pro Data Tools Releases

We plan to publish new Pro Data Tools updates and releases monthly. The best way to keep up to date on the new features and enhancements added to DuckDB Pro Tools extension, PRQL Pro Tools, recently released Markdown SQL Pro Tools, and the upcoming Data Notebook Pro extension is to follow us on LinkedIn @TarasNovak, or follow Data Samurai on Vis Social Mastodon. We share new Pro Data Tools related demos and content there frequently.

Pro Data Tools Changelog

We also created new combined Pro Data Tools changelog to capture all the premium VS Code extensions and versions with detailed features list released to our Pro sponsors on GitHub this year.

πŸ“œ https://github.com/RandomFractals/pro-data-tools/blob/main/CHANGELOG.md

Feedback

Please use our new Pro Data Tools GitHub Discussions portal to submit your feedback, share examples of how you are using our public VS Code data viz extensions and new Pro Data Tools, or request new trivial and premium features. Our goal with these generic Data Tools πŸ› οΈ and SQL Tools extensions is to make local and remote data more accessible and easier to use and visualize for all the devs and data scientists out there using VS Code IDE, VSCodium and Azure Data Studio.

Support

Become a Fan or a Pro Sponsor on GitHub to support our dev work on these Data Tools and other Random Fractals, Inc. code and data viz extensions if you find them useful, educational, or enhancing your daily dataViz dev code workflows and exploratory data analysis experience.

πŸ’– https://github.com/sponsors/RandomFractals

About

Pro Data Tools πŸ› οΈ for VS Code IDE πŸ§™β€β™‚οΈ: DuckDB Pro Tools, PRQL Code Lens, new Markdown SQL Pro Tools, upcoming Data Notebooks πŸ“š Pro Tools docs and demos, etc.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Sponsor this project

 

Packages

No packages published