Jam SQL Studio Jam SQL Studio Blog
News, guides, and tips for SQL developers.
SQL Editor IntelliSense Beyond Autocomplete
Most SQL editors stop at table/column autocomplete. Here's what modern SQL IntelliSense looks like: function parameter hints, column inlay hints, and inline result previews.
April 6, 202610 Query Editor Features for Faster SQL Development
Column profiling, FK navigation, pin results, copy as INSERT, client-side filtering, and more. 10 query editor features that speed up daily SQL work.
April 6, 2026How to Prevent Running Queries on the Wrong Database
Color-coded connections and destructive query confirmation help you avoid running DROP TABLE on production. Here's how to set up visual guardrails in your SQL editor.
March 20, 2026How to Manage SQL Server Agent Jobs on Mac and Linux
Azure Data Studio is retired and SSMS is Windows-only. Here's how to manage SQL Server Agent jobs — view, run, create, and monitor — from your Mac or Linux workstation.
March 19, 2026PL/SQL Debugging on Mac and Linux: The Gap Nobody Filled (Until Now)
For 8+ years, no cross-platform tool shipped a real PL/SQL step-through debugger. DBeaver couldn't do it. SQL Developer was too slow. Toad was Windows-only. Here's how Jam SQL Studio closes the gap.
March 19, 2026AI Skills for SQL Databases: Let Claude Code, Codex, and Cursor Query Your Data
Teach AI coding agents to query SQL Server, PostgreSQL, MySQL, Oracle, and SQLite with a single skill file. Works with Claude Code, Codex CLI, Cursor, Copilot, and more.
March 13, 2026SSMS for Mac — Best SQL Server Management Studio Alternatives in 2026
SSMS doesn't run on Mac. Here are the best SQL Server Management Studio alternatives for macOS in 2026, compared by features.
March 12, 2026Oracle Database on Mac and Linux: No Oracle Client Required
Connect to Oracle Database from Mac, Linux, or Windows without installing Oracle Client. Learn how Thin mode simplifies Oracle development across platforms.
March 7, 2026Why Your SQL IDE Should Have a Built-in MCP Server
AI coding assistants are everywhere, but they're blind to your database. A built-in MCP server changes that — here's why native beats bolt-on.
March 7, 2026How to Run SQL Server on macOS
Complete guide to running SQL Server on Mac: Azure SQL Edge via Docker, full SQL Server on Parallels with Ubuntu x86, and Windows ARM for SSMS.
February 17, 2026Connect AI Agents to Your Database with MCP
AI coding assistants can write SQL, but they can't see your schema. Learn how to connect Claude, Codex, and other AI agents to your SQL database using Model Context Protocol.
February 17, 2026How to Read SQL Execution Plans (Visual Guide)
Learn to read SQL execution plans step by step. Identify table scans, missing indexes, and common performance problems with this visual guide.
February 17, 2026SQL Notebooks: Run, Document, and Share SQL
Learn how SQL Notebooks help you document workflows, build runbooks, and share analysis. A practical guide with examples for data analysts and SQL developers.
February 17, 2026Azure Data Studio Is Retired: Your Complete Migration Guide for 2026
Azure Data Studio was retired on February 28, 2026. This complete guide covers the retirement timeline, what breaks, feature-by-feature comparison of alternatives, and step-by-step migration instructions.
February 12, 2026Azure Data Studio Has Been Retired — What Are Your Options?
Microsoft retired Azure Data Studio on February 28, 2026. Here's what happened, what breaks, and your migration options.
February 12, 2026Polyglot Notebooks Are Being Deprecated — What Now?
Polyglot Notebooks, part of the Azure Data Studio ecosystem, are being deprecated alongside ADS. Here's what you lose and what alternatives exist.
February 12, 2026SQLite Is More Powerful Than You Think
When you don't need a client-server database, SQLite might surprise you with its performance, reliability, and simplicity.
Download Jam SQL Studio
Connect to SQL Server, PostgreSQL, MySQL, Oracle, and SQLite. Free for personal use.