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.
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.
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.
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.
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.
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.
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.
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.
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.
Simple example of running SQL query with the new Data Notebook Pro Tools extension:
Using different Data Table Renderers in the Data Notebook created from SQL document with multiple SQL queries:
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.
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
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.
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.