Our new #MarkdownSQL #ProDataTools 🛠️ now support SQL code fences in #Quarto docs, and add #SQLCodeLenses 🧐 & #SQLBookmarks 📑 to .qmd markdown documents in #VSCode IDE.

Quick demo of setting up local HR #SQLite database with #SQLTools VS Code extension, rendering Quarto markdown document with Quarto VS Code extension, and using our new #MarkdownSQL Pro Tools to Execute SQL queries from standard .sql, .md, and .qmd markdown documents code:

📰 https://github.com/RandomFractals/pro-data-tools#interactive-sql-in-quarto-docs

📢 We released new version of #MarkdownSQL Pro Tools. New features:

✅ SQL code block highlights & selections

✅ Detection of %%sql magic code blocks & %sql magic code lines

✅ New #SQLBookmarks 📑

✅ New Extract All SQL code lens

✅ MyST #JupyterBook markdown documents support

✅ SQL code lenses for #Quarto, #Rmarkdown, and #ObservableJS docs

Docs and new demos at:

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

These tools are free today, for one day only. Sign up to try them out!

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

Updated #MarkdownSQLPro Tools info in our public #ProDataTools docs repo now:

https://github.com/RandomFractals/pro-data-tools#markdown-sql-pro-tools

We'll add demos of how to use new #SQLBookmarks and other features from our upcoming Markdown SQL v1.2.0 release with Quarto, R and Observable docs after lunch.

There are over 538K SQL code blocks in docs on GitHub:

🔎 https://github.com/search?q=%2F%60%60%60sql%5B%5Cs%5CS%5D*%3F%60%60%60%2F+language%3AMarkdown&type=code

We believe SQL code in docs should be runnable.

We created #SQLCodeLenses with new #SQLBookmarks 📑 in #MarkdownSQLPro Tools 🛠️ for VS Code IDE.

Get #SQLTools drivers to connect to data sources and run SQL queries:

📥 https://marketplace.visualstudio.com/search?term=tag%3Asqltools-driver&target=VSCode&category=All%20categories&sortBy=UpdatedDate

Our Markdown SQL Pro Tools add new SQL code lenses to enable direct SQL code interactions.

Subscribe to get notified when they will be released:

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

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 🧙‍♂️ ...