What happened to Polyglot Notebooks?

Microsoft deprecated Polyglot Notebooks on March 27, 2026, following the Azure Data Studio retirement. Jam SQL Studio supports opening Polyglot .ipynb files directly — SQL and JavaScript cells are preserved, while C# and F# cells are imported as Markdown. Jam SQL Notebooks also add multi-engine support (MSSQL, PostgreSQL, MySQL, SQLite), GUI connection management, and AI/MCP integration.

Does Jam SQL Studio have a Command Palette?

Yes. Press Cmd+Shift+P on macOS or Ctrl+Shift+P on Windows/Linux to open the Command Palette. It gives you fuzzy-searchable access to every workspace command, database object, saved connection, and setting. You can search for tables or views by name and drill down into contextual actions like Select Top, Script CREATE, Design Table, or View Dependencies — all without leaving the keyboard. Each command shows its keyboard shortcut badge, so the palette also works as a shortcut reference.

How do I get support for Jam SQL Studio?

For support, contact us at support@jamsql.com. Pro subscribers receive priority email support, and Enterprise customers get dedicated account management.

Does Jam SQL Studio have DBA tools?

Yes. Jam SQL Studio includes a Session Browser for monitoring and killing active sessions, a Performance Dashboard with real-time counters, top SQL, and wait statistics, a Tablespace Manager for Oracle storage, and a Filegroup Manager for SQL Server storage. All DBA tools work across Oracle, SQL Server, PostgreSQL, and MySQL on Mac, Windows, and Linux.

The cross-platform SQL IDE that replaces Azure Data Studio.

Open SQL Server, Postgres, MySQL, and Oracle from one app — with built-in AI agents and MCP. Free for personal use, on Mac, Windows, and Linux.

Jam SQL Studio table explorer with grid, filtering, and sidebar

Table Explorer in Jam SQL Studio — see the full tour

Live demo · click anywhere

Loading interactive demo...

📓 SQL Notebooks

⚡ IntelliSense

📊 Execution Plans

📈 Built-in Charts

⚖️ Schema Compare

🤖 AI Workspace + MCP

SQL Server PostgreSQL MySQL MariaDB Oracle SQLite Azure SQL

“A powerful and intuitive Mac-native SQL tool that makes working with complex, multi-schema databases seamless. The team is highly responsive and committed to continuously enhancing the user experience.”

John Du Toit, Senior Data & BI Architect (Cape Town, South Africa)

Download Try in Browser (SQLite only) Quick Tour

Free for personal use • No account required • Open MCP server

macOS Windows Linux

SQL IDE Comparison: How Jam SQL Studio Compares

Choosing the right SQL tool? Here's how Jam SQL Studio stacks up against other popular options.

Feature comparison as of January 2026. Features may vary by version.
Feature	Jam SQL Studio	Azure Data Studio	VS Code + MSSQL	SSMS	DBeaver	DataGrip
AI-Native (MCP + Workspace)	✓	✗	Limited	✗	✗	Limited
Claude Code CLI Integrated	✓	✗	✗	✗	✗	✗
SQL Notebooks (.ipynb)	✓	✓	Extension	✗	✗	✗
Cross-platform (Mac/Win/Linux)	✓	✓	✓	✗	✓	✓
Execution Plan Visualization	✓	✓	Basic	✓	✓	✓
Schema Compare	✓	✓	✗	✓	✓	✓
Data Compare	✓	✗	✗	Via tools	✓	✓
Built-in Charting	✓	✓	✗	✗	Pro only	✗
Free Tier Available	✓	✓	✓	✓	✓	✓
SQL Server Support	✓	✓	✓	✓	✓	✓
PostgreSQL Support	✓	✓	Extension	✗	✓	✓
MySQL / MariaDB Support	✓	✗	✗	✗	✓	✓
Oracle Support	✓	✗	✗	✗	✓	✓
DBA Tools (Sessions, Performance)	✓ 4 engines	✗	✗	✓	Plugin	Limited
Modern UI	✓	✓	✓	Classic	✓	✓

What developers are saying

Real feedback from teams who have switched to Jam SQL Studio.

“As an abandoned user of Azure Data Studio, I was left looking for a good replacement… JamSQL is my new go-to tool for SQL.”

Robb Schiefer, VP of Software

“I recently switched to Linux from Windows. As a full stack dev my only missing piece was a solid SQL client. You guys filled it.”

Craig Geil, independent consultant, Geil Tech LLC

How to Migrate from Azure Data Studio

Moving from Azure Data Studio to Jam SQL Studio takes just a few minutes. Here's everything you need to know to make the switch before the February 2026 deadline.

Download Jam SQL Studio

Download Jam SQL Studio for your operating system (macOS, Windows, or Linux) and install it. No account required — the app is ready to use immediately.

Re-create Your Database Connections

Open Jam SQL Studio and add your SQL Server, PostgreSQL, MySQL, Oracle, or Azure SQL connections. Use the same server addresses and credentials from Azure Data Studio. Supports SQL authentication, Windows auth, and Microsoft Entra ID.

Transfer Your SQL Scripts

Copy your .sql query files from your Azure Data Studio workspace to any folder on your computer. Open them directly in Jam SQL Studio — they work exactly the same way, with full IntelliSense support.

Explore New Features

Discover capabilities beyond Azure Data Studio: AI workspace sync for coding agents, built-in charting, data compare, and more. Use familiar keyboard shortcuts from SSMS and Azure Data Studio.

What You Can Bring to Jam SQL Studio

SQL query files (.sql) Notebook files (.ipynb) Connection credentials Database projects Saved scripts Keyboard shortcuts

Download Jam SQL Studio Free

Free for personal use — no credit card, no account required.

Everything You Need

Six pillars covering every stage of SQL development — from writing queries to operating production databases.

🤖

AI-Native

The first SQL IDE built for AI agents. Local MCP server, AI Workspace, and an in-app Claude Code chat — all opt-in and localhost-only.

Local MCP server (13 tools, 9 resources)
AI Workspace with auto-generated CLAUDE.md + schema export
In-app Claude Code chat sidebar
jam-sql CLI for terminal access
Bearer token auth, audit logs, read-only by default

🗄️

Universal Database Support

One IDE for every engine your team runs — with consistent IntelliSense, schema browsing, and editor UX across the lot.

SQL Server, Azure SQL, Postgres, MySQL, MariaDB
Oracle 12.2+ / 19c / 21c / 23ai (Thin mode — no client)
SQLite for local files and demos
Microsoft Entra ID auth (device code, MFA-friendly)
Smart, context-aware IntelliSense everywhere

📊

Analysis & Comparison

Understand your data and your schema. Compare environments, profile queries, and ship visualizations without leaving the editor.

Visual execution plans (tree + graph, side-by-side compare)
Schema compare with ALTER/CREATE/DROP sync scripts
Data compare with INSERT/UPDATE/DELETE diffs
Built-in charting: bar, line, pie, area, scatter
SQL Notebooks (Jupyter-compatible .ipynb)
Dependency viewer + visual schema overview

👁️

DBA & Operations

Production-grade tools for the people who keep databases running — across four engines, on every OS.

Session Browser — monitor and kill active sessions
Performance Dashboard — counters, top SQL, wait stats
Tablespace Manager (Oracle) + Filegroup Manager (SQL Server)
Backup & Restore (.bak, .bacpac, pg_dump)
One-click clone of databases and tables

⌨️

Productive Editor

Every shortcut, every drill-down, every workflow you expect from a premium IDE — without the licensing fees.

Command Palette (Cmd+Shift+P) for everything
Table Explorer with inline editing and FK lookups
Script generation (CREATE/ALTER/DROP/SELECT/INSERT)
Query history, snippets, and script management
Per-tab transaction control + integrated terminal
Data export to CSV, JSON, XLSX

🌐

Cross-Platform & Free

Native on Mac, Windows, and Linux. Free for personal use forever — no account, no telemetry, no surprise paywalls.

macOS (Apple Silicon + Intel), Windows, Linux (deb/rpm)
Modern UI with full dark mode and SSMS/ADS shortcuts
Session persistence — resume exactly where you left off
Free Personal tier, no account required
14-day Pro trial unlocks automatically — no credit card

Database Support

Connect to your favorite databases with full IntelliSense and query execution support.

🪶

SQLite

View all supported databases →

AI-Native Database Tooling

The first SQL IDE designed from the ground up for AI coding assistants — with a full MCP server, 13 tools, 9 resources, and secure local-first architecture.

🏠

AI Workspace Inside the App

Use the integrated terminal with file-backed tabs. AI edits .sql files, your editor updates in real-time.

Bidirectional file sync
Auto-generated context
(CLAUDE.md, AGENTS.md)
Schema export to .schema/
Results history to .history/
Knowledge pack in .knowledge/

🔌

MCP Server Outside the App

Jam SQL Studio runs a local MCP server so external AI tools can safely interact with your databases, query editors, and SQL notebooks.

13 MCP tools & 9 resources
Control query editor & notebook tabs
Localhost-only (127.0.0.1)
Bearer token authentication
Read-only by default

💬

AI Chat Claude Code CLI

Chat with Claude directly inside Jam SQL Studio. Uses your local Claude Code CLI installation — your subscription, your settings, your context.

Claude Code CLI integrated in-app
Re-uses your local subscription
Full database context via @-mentions
Schema-aware conversations
No extra API keys needed

See What AI Agents See

When you open an AI Workspace, Jam SQL Studio auto-generates context files that give AI agents everything they need to understand your database.

~/my-project/.ai-workspace

$ cat CLAUDE.md

# Jam SQL Studio - AI Context

## Active Connection
- Name: Production DB
- Engine: PostgreSQL 15.2
- Database: ecommerce_prod

## Database Schema
Tables: 24 | Views: 8 | Functions: 12

users (id, email, name, created_at, subscription_tier)
orders (id, user_id → users.id, total, status, created_at)
products (id, name, price, category_id → categories.id)
order_items (order_id → orders.id, product_id → products.id, qty)

## MCP Tools Available
✓ query_execute - Run read-only SQL (SELECT, EXPLAIN)
✓ connections_list - List saved connections
✓ ui_open_tab - Open query/table tabs
✓ ui_set_editor_text - Write SQL to editor

## Quick Examples
# Get top customers by order count
SELECT u.name, COUNT(o.id) as order_count
FROM users u JOIN orders o ON u.id = o.user_id
GROUP BY u.id ORDER BY order_count DESC LIMIT 10;

# Check index usage
EXPLAIN ANALYZE SELECT * FROM orders WHERE status = 'pending';

## Files in Workspace
.schema/users.sql       # CREATE TABLE DDL
.schema/orders.sql      # CREATE TABLE DDL
.history/2024-01-19.md  # Today's query results
queries/analysis.sql    # Your active query tab

The CLAUDE.md file is auto-generated and stays in sync with your active connection and schema. AI agents read this file to understand your database structure before writing queries.

🔒

Privacy First: Opt-In by Default

AI features are disabled by default. Query results history, write operations, and detailed context sharing must be explicitly enabled in Settings → AI Integrations. You control exactly what AI agents can see and do.

MCP Server Capabilities

A complete toolset for AI-driven database workflows

🔗 Connection Tools

connections_list — List saved connections (no secrets)
query_execute — Execute read-only SQL queries

🖥️ UI Control Tools

ui_open_tab — Open query editor or SQL notebook tabs
ui_focus_tab — Switch to a specific tab
ui_set_editor_text — Write SQL to query editor or notebook cells
ui_close_tab — Close tabs
ui_lock_tab / ui_unlock_tab — Prevent conflicts
ui_check_abort — Check for user abort requests

📊 Table Viewer Tools

table_set_filter — Apply column filters
table_set_sort — Sort by column
table_set_pagination — Navigate pages
table_get_snapshot — Get current table state

📖 Context Resources

workspace_snapshot — Active workspace state
connections_snapshot — Connection status
tabs_snapshot — Open tabs and editors
editor_snapshot — Active editor content
results_snapshot — Query results preview
selection_snapshot — Selected explorer item

📚 Knowledge Resources

app_manifest — App version & features
app_capabilities — Supported workflows
app_user_guide — How-to documentation

Works With Your Favorite AI Tools

🤖 Claude Desktop

💻 Claude Code

📦 Codex CLI

⚡ OpenCode

🐙 GitHub Copilot

🔧 Custom Agents

🔐

Secure by Default

MCP server binds to 127.0.0.1 only. Bearer token required. Strict read-only queries by default. Configurable policy levels (block, confirm, allow). Full audit logging of every tool call.

Command-Line Access with `jam-sql` CLI

Use Jam SQL Studio from any terminal. The Go-based CLI wraps the MCP server for quick database access.

jam-sql doctor — Check installation & MCP status
jam-sql connections — List saved connections
jam-sql query -c prod "SELECT * FROM users LIMIT 5"
jam-sql tools / jam-sql resources — Explore MCP

Terminal

$ jam-sql doctor
✓ Jam SQL Studio installed
✓ MCP server running on :14507
✓ Authentication configured
✓ Read-only mode enabled

$ jam-sql connections
ID        NAME          ENGINE      SERVER
conn_1    Production    PostgreSQL  prod-db.company.com
conn_2    Staging       MSSQL       staging.database.windows.net

Read the AI & MCP Documentation

Execution Plan Viewer in Jam SQL Studio showing tree view with operator cost breakdown

Deep Query Analysis

Understand exactly how your queries execute with detailed execution plan visualization.

Tree and graph view modes
Operator cost breakdown
Plan comparison side-by-side
Import/export for team sharing
Search and highlight expensive operations

Table Explorer in Jam SQL Studio showing data grid with filtering and sorting

Powerful Data Exploration

Browse, filter, and edit your data with a spreadsheet-like interface designed for databases.

Advanced filtering and sorting
Inline cell editing with validation
Foreign key lookup popovers
Row details panel with JSON preview
Multi-format data export

What's Next: PostGIS Support

Visualize geometry columns on a map, spatial data types, and query result map rendering — coming soon for PostgreSQL users.

See Roadmap

Simple, Transparent Pricing

Start free with a 14-day Pro trial. No credit card required.

Personal

Free

Forever

Unlimited SQL Server connections
Unlimited PostgreSQL connections
Unlimited MySQL connections
IntelliSense & auto-complete
Query execution & results
Table explorer & data editing
Basic charting
AI Workspace sync
Execution plan analysis
Priority support

Download Free

Pro Monthly

$9.99

per month

Everything in Personal
AI Workspace sync
Execution plan visualization
Advanced charting & export
Schema comparison tools
Priority email support
Commercial use license

Try Pro Free for 14 Days

Download the app → trial starts in one click. No credit card.

Best Value

Pro Yearly

$99

per year

Save 17% vs monthly

Everything in Personal
AI Workspace sync
Execution plan visualization
Advanced charting & export
Schema comparison tools
Priority email support
Commercial use license

Start Trial — Save 17%

Download the app → trial starts in one click. No credit card.

All plans include a 14-day free trial of Pro features. No credit card required • Cancel anytime in-app. Download now to start your trial.

Frequently Asked Questions

Everything you need to know about Jam SQL Studio and migrating from Azure Data Studio.

What is happening to Azure Data Studio?

Microsoft retired Azure Data Studio on February 28, 2026, as announced on February 6, 2025. Microsoft recommends users migrate to the VS Code MSSQL extension or SQL Server Management Studio (SSMS).

However, these alternatives lack many features that made Azure Data Studio popular, such as built-in charting, cross-platform support (for SSMS), and a modern UI. Jam SQL Studio is designed to be a complete replacement with additional features like AI agent support.

Is Jam SQL Studio free?

Yes! Jam SQL Studio offers a free Personal tier that includes unlimited SQL Server and PostgreSQL connections, IntelliSense, query execution, table explorer, and basic charting — forever free with no account required.

Pro features like AI Workspace sync, execution plan visualization, and schema comparison are available through monthly ($9.99/mo) or annual ($99/yr) subscriptions. All new users get a 14-day free trial of Pro features.

Does Jam SQL Studio work on Mac, Windows, and Linux?

Yes! Jam SQL Studio is a cross-platform desktop application available for macOS, Windows, and Linux. Unlike SSMS which only runs on Windows, you can use Jam SQL Studio on any major operating system with the same features and experience.

We also offer a browser-based demo that runs SQLite directly in your browser — great for trying out the interface before downloading.

What databases does Jam SQL Studio support?

Jam SQL Studio currently supports:

Microsoft SQL Server — Full support including Azure SQL Database and Managed Instance
PostgreSQL — Including Azure Database for PostgreSQL and Amazon RDS
MySQL — MySQL 5.7+ and 8.x, including Amazon RDS and Azure Database for MySQL
MariaDB — MariaDB 10.x and 11.x
Oracle Database — Oracle 12.2+, 19c, 21c, and 23ai with Thin mode (no Oracle Client required). Full support for PL/SQL, packages, sequences, synonyms, DB links, and materialized views
SQLite — Local file-based databases

All database engines include IntelliSense, query execution, table explorer, and data export capabilities.

How does Jam SQL Studio compare to SSMS?

SQL Server Management Studio (SSMS) is a powerful tool but has limitations. Jam SQL Studio offers several advantages:

Cross-platform SQL client — Works on Mac and Linux, not just Windows
Modern UI — Clean, responsive interface with dark mode
AI Agent Support — First-class integration with AI coding assistants
Built-in Charting — Create visualizations directly from query results
PostgreSQL Support — Connect to PostgreSQL alongside SQL Server

Jam SQL Studio includes execution plans, schema compare, and data compare features that SSMS users rely on.

Does Jam SQL Studio support AI coding assistants?

Yes. Jam SQL Studio supports AI coding assistants in three complementary ways:

Claude Code-powered AI Chat Sidebar — A built-in chat panel in the Query Editor and SQL Notebooks powered by your locally installed Claude Code CLI. No extra subscription — reuses your existing Claude Code setup. Ask questions, get SQL suggestions, and let Claude interact with your database.
AI Workspace (inside the app) — Query tabs sync to .sql files, plus auto-generated context files (schema, history, results). Iterate with AI agents in the integrated terminal.
MCP Tooling (outside the app) — Jam SQL Studio runs a local MCP server (Model Context Protocol) so external AI apps can safely list connections (no passwords) and execute policy-controlled queries.

Works with Claude Code, Claude Desktop, OpenCode, Codex CLI, GitHub Copilot, and other AI agents.

Does Jam SQL Studio support MCP (Model Context Protocol)?

Yes. Jam SQL Studio can run a local MCP server (Model Context Protocol) so AI agents can list saved connections (no passwords) and execute strict read-only queries (SELECT/EXPLAIN).

The MCP endpoint is localhost-only and protected with a bearer token, so it stays on your machine.

Can I import my Azure Data Studio settings?

Currently, Jam SQL Studio does not have an automatic import feature for Azure Data Studio settings. However, migrating is straightforward:

Connections — Re-create your server connections (one-time setup)
Queries — Copy your .sql files to any folder and open them
Keyboard Shortcuts — Jam SQL Studio uses familiar shortcuts from SSMS and Azure Data Studio

We're considering an import wizard for a future release based on user feedback.

How do I get support?

For support, contact us at [email protected].

Personal Tier — Email support for all users
Pro Subscribers — Priority email support with faster response times
Enterprise — Dedicated account management and custom SLAs available

Download Jam SQL Studio

Free for personal use, on every platform. Pro features unlock a 14-day trial automatically — no credit card required.

The cross-platform SQL IDE that replaces Azure Data Studio.

Azure Data Studio stopped getting updates in February. Move your workflows in 15 minutes.

SQL IDE Comparison: How Jam SQL Studio Compares

What developers are saying

How to Migrate from Azure Data Studio

Download Jam SQL Studio

Re-create Your Database Connections

Transfer Your SQL Scripts

Explore New Features

What You Can Bring to Jam SQL Studio

Ready in under a minute

Everything You Need

AI-Native

Universal Database Support

Analysis & Comparison

DBA & Operations

Productive Editor

Cross-Platform & Free

Database Support

AI-Native Database Tooling

AI Workspace Inside the App

MCP Server Outside the App

AI Chat Claude Code CLI

See What AI Agents See

MCP Server Capabilities

🔗 Connection Tools

🖥️ UI Control Tools

📊 Table Viewer Tools

📖 Context Resources

📚 Knowledge Resources

Works With Your Favorite AI Tools

Secure by Default

Command-Line Access with jam-sql CLI

Deep Query Analysis

Powerful Data Exploration

What's Next: PostGIS Support

Simple, Transparent Pricing

Personal

Pro Monthly

Pro Yearly

Enterprise

Frequently Asked Questions

Download Jam SQL Studio

Comparing SQL Tools?

vs Azure Data Studio

vs DBeaver

vs SSMS

vs DataGrip

vs HeidiSQL

vs Navicat

vs TablePlus

vs Beekeeper Studio

vs Toad for Oracle

vs Oracle SQL Developer

Command-Line Access with `jam-sql` CLI