Repository files navigation

Random Fractals Inc.Data Tools 🛠️ is a collection of publicdata visualization extensions,data viewers, VS CodeNotebook renderers, andcode snippets for devs and data scientists using VS Code IDE, published under ourRandom Fractals Inc. ☂️ org.

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

OurPro Data Tools 🛠️ includeDuckDB Pro Tools extension that adds advancedDuckDB 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 publicDuckDB SQL ToolsPreview VS Code extension and new PremiumDuckDB Pro Tools extension capabilites and features in our newDuckDB Tools documentation page.

Pro Data Tools VS Code extensions also includeSQLite Pro Tools.SQLite Pro Tools provide over a dozen of common SQLite database shortcutCommands, display table column data type and primary key indicators, SQLite databaseIndexes,Modules,Configuration Settings andFunctions.

OurPro sponsors on GitHub also get access to the PremiumPRQL Pro Tools VS Code extension.PRQL Pro Tools extension comes with a customPRQL Code Lens SQL Tools plugin that allows you to runPRQL queries for the supported PRQL targetSQL dialectsdirectly using any of the supported SQL Tools extension drivers for the different database management systems.

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

The providedSQL Code Lenses include top-level SQL and markdown documentExecute All,Select All,Extract All,Bookmark All SQL code lenses,Execute,Select, andCopy SQL code block lenses, andCreate New SQL document from SQL code block lens.

OurSQL Code Lenses integrate with the popularSQL Tools Connections manager, supportedSQL Tools drivers, and query results viewer to execute SQLdirectly on any of the supported SQL Tools database management systems and view results.

Markdodown SQL Pro Tools extension is available under the newMarkdown Sql Pro Tools monthly sponsor subscription on GitHub and also includes access to theDuckDB Pro SQL Tools plugin andPRQL Code Lens extension from our PremiumPro Data Tools extensions pack.

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

Data Notebook Pro extension integrates SQL Tools connections, supported database management systems, ourData 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 newData Notebook Pro Tools extension:

Using differentData Table Renderers in theData Notebook created from SQL document with multiple SQL queries:

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

We also created new combinedPro Data Toolschangelog to capture all the premium VS Code extensions and versions with detailed features list released to ourPro sponsors on GitHub this year.

📜https://github.com/RandomFractals/pro-data-tools/blob/main/CHANGELOG.md

Please use our newPro Data Tools GitHub Discussions portal to submit your feedback, share examples of how you are using our public VS Codedata viz extensions and newPro 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 aFan or a Pro Sponsor on GitHub to support our dev work on these Data Tools and otherRandom 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