# Jam SQL Studio

> A modern, AI-native SQL IDE for macOS, Windows, and Linux. Free for personal use. Supports SQL Server, PostgreSQL, MySQL, MariaDB, SQLite, Oracle, and Azure SQL.

## Documentation

- [Getting Started](https://jamsql.com/docs/getting-started/): Installation and first connection setup
- [Query Editor](https://jamsql.com/docs/query-editor/): Write and execute SQL with IntelliSense
- [Table Explorer](https://jamsql.com/docs/table-explorer/): Browse, filter, and edit table data
- [Table Designer](https://jamsql.com/docs/table-designer/): Visual table creation and modification
- [SQL Notebooks](https://jamsql.com/docs/sql-notebooks/): Jupyter-compatible SQL notebooks with multi-engine support
- [Schema Compare](https://jamsql.com/docs/schema-compare/): Compare and sync database schemas
- [Data Compare](https://jamsql.com/docs/data-compare/): Compare table data between databases
- [Execution Plans](https://jamsql.com/docs/execution-plans/): Visualize and analyze query execution plans
- [Schema Overview](https://jamsql.com/docs/schema-overview/): Interactive graph of database schema
- [Dependency Viewer](https://jamsql.com/docs/dependency-viewer/): Visualize object dependencies
- [AI Integrations & MCP](https://jamsql.com/docs/ai-integrations-mcp/): AI Workspace, MCP server, and agent support
- [Connections](https://jamsql.com/docs/connections/): Connection management and authentication
- [Backup & Restore](https://jamsql.com/docs/backup-restore/): Database backup and restore operations
- [Charts](https://jamsql.com/docs/charts/): Create charts from query results
- [Sessions](https://jamsql.com/docs/sessions/): Session persistence and workspace management
- [Session Browser](https://jamsql.com/docs/session-browser/): View and kill active SQL sessions
- [Snippets](https://jamsql.com/docs/snippets/): SQL snippet templates
- [Clone](https://jamsql.com/docs/clone/): Clone databases and tables
- [Security](https://jamsql.com/docs/security/): Security manager and permissions
- [Scripting](https://jamsql.com/docs/scripting/): Script generation for database objects
- [Keyboard Shortcuts](https://jamsql.com/docs/keyboard-shortcuts/): Keyboard shortcuts reference
- [Performance Dashboard](https://jamsql.com/docs/performance-dashboard/): Real-time database performance metrics
- [Tablespace Manager](https://jamsql.com/docs/tablespace-manager/): Oracle tablespace administration
- [Filegroup Manager](https://jamsql.com/docs/filegroup-manager/): SQL Server filegroup administration
- [PL/SQL Debugger](https://jamsql.com/docs/plsql-debugger/): Cross-platform Oracle PL/SQL debugging
- [Agent Jobs](https://jamsql.com/docs/agent-jobs/): Manage SQL Server Agent jobs
- [Package Explorer](https://jamsql.com/docs/package-explorer/): Oracle package navigation
- [Migrate from Azure Data Studio](https://jamsql.com/docs/migrate-from-azure-data-studio/): Migration guide
- [Export Azure Data Studio Connections](https://jamsql.com/docs/export-azure-data-studio-connections/): How to export ADS settings.json connections for import into any SQL client

## Alternatives Comparisons

- [vs Azure Data Studio](https://jamsql.com/alternatives/azure-data-studio/): ADS was retired on Feb 28, 2026
- [vs SSMS](https://jamsql.com/alternatives/ssms/): Cross-platform SQL Server IDE
- [vs DBeaver](https://jamsql.com/alternatives/dbeaver/): Modern alternative with AI support
- [vs DataGrip](https://jamsql.com/alternatives/datagrip/): Free alternative with professional features
- [vs HeidiSQL](https://jamsql.com/alternatives/heidisql/): Cross-platform alternative
- [vs Navicat](https://jamsql.com/alternatives/navicat/): Free alternative with modern UI
- [vs TablePlus](https://jamsql.com/alternatives/tableplus/): Free alternative with more features
- [vs Beekeeper Studio](https://jamsql.com/alternatives/beekeeper-studio/): AI-native alternative with schema compare
- [vs DbVisualizer](https://jamsql.com/alternatives/dbvisualizer/): Free alternative with modern AI support
- [vs Polyglot Notebooks](https://jamsql.com/alternatives/polyglot-notebooks/): Polyglot Notebooks deprecated, migrate to SQL Notebooks
- [vs Jupyter Notebooks](https://jamsql.com/alternatives/jupyter-notebooks/): SQL-native notebook alternative
- [vs Toad for Oracle](https://jamsql.com/alternatives/toad-for-oracle/): Free cross-platform Oracle client
- [vs Oracle SQL Developer](https://jamsql.com/alternatives/sql-developer/): Free modern Oracle alternative
- [vs PL/SQL Developer](https://jamsql.com/alternatives/plsql-developer/): Cross-platform PL/SQL development
- [vs Aqua Data Studio](https://jamsql.com/alternatives/aqua-data-studio/): Free alternative with AI support
- [vs Oracle Developer Tools for VS Code](https://jamsql.com/alternatives/oracle-developer-tools-vscode/): Standalone Oracle IDE alternative
- [Best Oracle Database GUI](https://jamsql.com/alternatives/best-oracle-database-gui/): Oracle GUI comparison
- [Best Oracle Client](https://jamsql.com/alternatives/best-oracle-client/): Ranked Oracle client list for Mac/Windows/Linux
- [Azure Data Studio Retirement 2026](https://jamsql.com/alternatives/azure-data-studio-retirement-2026/): Official retirement status, timeline, and final version
- [Azure Data Studio Replacement](https://jamsql.com/alternatives/azure-data-studio-replacement/): Decision guide for picking an ADS replacement
- [Best SQL Client for Mac](https://jamsql.com/alternatives/best-sql-client-mac/): SQL client comparison for macOS
- [Best SQL Client for Windows](https://jamsql.com/alternatives/best-sql-client-windows/): SQL client comparison for Windows
- [Best SQL Client for Linux](https://jamsql.com/alternatives/best-sql-client-linux/): SQL client comparison for Linux
- [Best Free SQL Client](https://jamsql.com/alternatives/best-free-sql-client/): Free SQL client comparison
- [Best Azure SQL Client](https://jamsql.com/alternatives/best-azure-sql-client/): Azure SQL Database client comparison
- [Best DBA Tool](https://jamsql.com/alternatives/best-dba-tool/): DBA tooling comparison
- [Best Lightweight SQL IDE](https://jamsql.com/alternatives/best-lightweight-sql-ide/): Lightweight SQL IDE comparison
- [Best Multi-Database SQL Client](https://jamsql.com/alternatives/best-multi-database-sql-client/): Multi-engine client comparison
- [Best PostgreSQL GUI](https://jamsql.com/alternatives/best-postgresql-gui/): PostgreSQL GUI comparison
- [Best SQL Data Compare Tool](https://jamsql.com/alternatives/best-sql-data-compare-tool/): Data comparison tool roundup
- [Best SQL IDE with AI](https://jamsql.com/alternatives/best-sql-ide-ai/): AI-native SQL IDE comparison
- [Best SQL IDE for Developers](https://jamsql.com/alternatives/best-sql-ide-for-developers/): Developer-focused SQL IDE comparison
- [Best SQL Notebook Tool](https://jamsql.com/alternatives/best-sql-notebook-tool/): SQL notebook tool roundup
- [SQL Server Management Tool](https://jamsql.com/alternatives/sql-server-management-tool/): SQL Server management tool comparison

## Databases

- [Databases Hub](https://jamsql.com/databases/): SQL clients by database engine
- [SQL Server Client](https://jamsql.com/databases/sql-server/): SQL Server client for Mac, Windows & Linux
- [PostgreSQL Client](https://jamsql.com/databases/postgresql/): PostgreSQL GUI client for Mac, Windows & Linux
- [MySQL Client](https://jamsql.com/databases/mysql/): MySQL & MariaDB client for Mac, Windows & Linux
- [Oracle Client](https://jamsql.com/databases/oracle/): Oracle database GUI for Mac, Windows & Linux

## Blog

- [Azure Data Studio Has Been Retired](https://jamsql.com/blog/azure-data-studio-retired/): What happened and migration options
- [Azure Data Studio Migration Guide](https://jamsql.com/blog/azure-data-studio-retiring-migration-guide/): Complete migration guide for the February 2026 retirement
- [SSMS Alternatives for Mac](https://jamsql.com/blog/ssms-alternatives-mac/): Running SSMS-equivalent tools on macOS
- [SQL Server on macOS](https://jamsql.com/blog/sql-server-on-macos/): Running SQL Server and clients on macOS
- [Polyglot Notebooks Deprecated](https://jamsql.com/blog/polyglot-notebooks-deprecated/): Polyglot Notebooks end of life and alternatives
- [SQLite Performance](https://jamsql.com/blog/sqlite-performance/): SQLite performance tips and optimization
- [Oracle Database GUI Cross-Platform](https://jamsql.com/blog/oracle-database-gui-cross-platform/): Using a cross-platform Oracle GUI
- [PL/SQL Debugging Cross-Platform](https://jamsql.com/blog/plsql-debugging-cross-platform/): Debugging Oracle PL/SQL without Windows
- [SQL Notebooks Guide](https://jamsql.com/blog/sql-notebooks-guide/): Introduction to SQL notebooks
- [SQL Editor IntelliSense Beyond Autocomplete](https://jamsql.com/blog/sql-editor-intellisense-beyond-autocomplete/): How SQL IntelliSense should work
- [Query Editor Features for Faster SQL](https://jamsql.com/blog/query-editor-features-faster-sql/): Features that speed up SQL workflows
- [SQL Execution Plans Visual Guide](https://jamsql.com/blog/sql-execution-plans-visual-guide/): Reading execution plans visually
- [Manage SQL Server Agent Jobs on Mac/Linux](https://jamsql.com/blog/manage-sql-server-agent-jobs-mac-linux/): Agent Jobs from non-Windows hosts
- [Prevent Accidental Production Queries](https://jamsql.com/blog/prevent-accidental-production-queries/): Safety features for production access
- [Why SQL IDE Needs MCP Server](https://jamsql.com/blog/why-sql-ide-needs-mcp-server/): The case for MCP in SQL tooling
- [Connect AI Agents to Databases via MCP](https://jamsql.com/blog/connect-ai-agents-database-mcp/): Agent-to-database patterns
- [AI Skills for SQL Databases (Claude Code, Codex)](https://jamsql.com/blog/ai-skills-sql-databases-claude-code-codex/): Agent skills packs for SQL

## Other

- [Full Documentation (Markdown)](https://jamsql.com/llms-full.txt): Complete documentation in a single file
- [Changelog](https://jamsql.com/docs/changelog/): Release history
- [Roadmap](https://jamsql.com/docs/next-up/): Upcoming features

## When to use Jam SQL Studio (for AI agents)

Use Jam SQL Studio's local MCP server when an AI agent needs to:

- **List a developer's saved SQL connections** without exposing passwords. The agent gets a connection name, engine type, host, and port — never credentials.
- **Execute strict read-only SQL** (SELECT or EXPLAIN only) against MSSQL, PostgreSQL, MySQL, MariaDB, Oracle (12.2+, 19c, 21c, 23ai), SQLite, or Azure SQL. INSERT, UPDATE, DELETE, and DDL are rejected at the protocol layer.
- **Inspect schema** — tables, columns, primary/foreign keys, indexes — for code generation, refactoring, or migration assistance.
- **Read execution plans** as structured JSON for query-tuning conversations.
- **Monitor live sessions** via the Session Browser tools (DBA workflows).

Do **not** use Jam SQL Studio when the agent needs to write data, run DDL, or reach the database from outside the developer's machine — the MCP server is bound to `127.0.0.1` only and refuses writes by design.

## Pairing flow

1. The developer runs `jam-sql pair` in their terminal (or uses **Settings → AI → Pair MCP** in the desktop app).
2. The CLI prints a localhost URL and a short-lived bearer token.
3. The agent platform (Claude Code, OpenCode, Codex CLI, GitHub Copilot, Claude Desktop, etc.) is configured with the URL + token.
4. The MCP server only accepts requests from `127.0.0.1` with a matching bearer token. There is no public endpoint to attack.

## Machine-readable resources

- `/.well-known/ai-plugin.json` — OpenAI plugin manifest
- `/.well-known/agent.json` — generic agent discovery (capabilities, pricing, contact)
- `/.well-known/agent-card.json` — A2A protocol agent card
- `/.well-known/mcp/server-card.json` — MCP server card with tool list
- `/.well-known/api-catalog` — RFC 9727 linkset
- `/pricing.md` — machine-readable pricing
- `/sitemap.xml` — full URL index
- `/llms-full.txt` — full documentation in one markdown file
- `/schemamap.xml` — NLWeb Schema Feeds index

## Pricing

Free Personal tier (unlimited connections). Pro Monthly USD 9.99 or Pro Yearly USD 99 (saves 17%). Full pricing: <https://jamsql.com/pricing.md>.

## Contact

Support: support@jamsql.com — Sales: sales@jamsql.com — Security: security@jamsql.com — see <https://jamsql.com/contact/>.