# 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, Azure SQL, and Azure Data Explorer (Kusto / KQL).

## 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
- [Import Data](https://jamsql.com/docs/import-data/): Import CSV, TSV, Excel (XLSX), JSON, and NDJSON into a new or existing table — column mapping, row filters, and error handling across all five engines
- [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 schemas across SQL Server, PostgreSQL, MySQL, MariaDB, Oracle, and SQLite — side-by-side DDL diff and engine-specific sync scripts
- [Data Compare](https://jamsql.com/docs/data-compare/): Compare table data between databases
- [Database Blueprint](https://jamsql.com/docs/database-blueprint/): Materialize a database as a Git-friendly folder of per-object .sql files — two-way sync, three-way merge, apply back via Schema Compare, table-data capture
- [Cross-Engine Database Migration](https://jamsql.com/docs/cross-engine-database-migration/): Migrate tables + data between any pair of SQL Server/PostgreSQL/MySQL/Oracle/SQLite via a canonical type model; views/procedures/triggers stay manual
- [T-SQL vs PL/pgSQL](https://jamsql.com/docs/t-sql-vs-plpgsql/): Side-by-side dialect reference for porting T-SQL to PL/pgSQL — variables, control flow, TRY/CATCH→EXCEPTION, temp tables, renamed built-ins
- [Finish a PostgreSQL Schema After Migration](https://jamsql.com/docs/finish-postgresql-schema-after-migration/): Day-after checklist after migrating SQL Server tables — port views/procedures/triggers, resolve type/default/collation warnings, verify with Data Compare
- [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
- [Virtual Foreign Keys (Loose Relationships)](https://jamsql.com/docs/loose-foreign-keys/): Declare virtual/unenforced foreign keys without touching the schema — source/target filters for polymorphic associations, JSON-path and array support, all 5 engines
- [JSON Columns](https://jamsql.com/docs/json-columns/): Filter, inspect, and declare JSON columns across all 5 engines — JSONPath sub-operators, peek popover for path discovery, JSON tree/code cell viewer, declared-on-text validity guards
- [Enum Columns](https://jamsql.com/docs/enum-columns/): Declare any column as an enum and get a dropdown filter — values from native enums, CHECK constraints, sampled distinct values, or (for FK columns) live names from the referenced table; JSON-path enums supported
- [Spatial / PostGIS](https://jamsql.com/docs/spatial/): View geometry & geography on interactive maps across PostgreSQL/PostGIS, MySQL, SQL Server, Oracle and SQLite — peek maps, Map view, spatial filters, Spatial Explorer, curve support
- [Kusto / KQL](https://jamsql.com/docs/kusto-kql/): Connect to Azure Data Explorer clusters and App Insights/Log Analytics proxies — KQL IntelliSense in editor and notebooks, read-only browsing, | render charts, ADS import
- [AI Integrations & MCP](https://jamsql.com/docs/ai-integrations-mcp/): Connect Claude Code, Cursor, and Codex to SQL databases via the local MCP server
- [Connections](https://jamsql.com/docs/connections/): Connection management and authentication
- [Browse Azure](https://jamsql.com/docs/browse-azure/): pick ADX clusters, App Insights, Log Analytics, Azure SQL, and PostgreSQL flexible servers from your signed-in Azure account
- [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/): Step-by-step Azure Data Studio migration guide for the Feb 28, 2026 retirement — connections, notebooks, snippets, keybindings
- [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 VS Code MSSQL extension](https://jamsql.com/alternatives/vscode-mssql/): Standalone SQL Server IDE alternative to Microsoft's VS Code MSSQL extension — schema compare, data compare, charts, one-click Azure Data Studio import
- [Kusto Explorer alternative](https://jamsql.com/alternatives/kusto-explorer/): Cross-platform Kusto.Explorer alternative — run KQL against Azure Data Explorer, App Insights, and Azure Monitor on Mac, Windows, and Linux, alongside SQL databases
- [Application Insights query tool](https://jamsql.com/alternatives/application-insights-query-tool/): Desktop KQL editor for Application Insights and Azure Monitor / Log Analytics — IntelliSense, fast filtering, and | render charts without the Azure Portal
- [PostGIS viewer](https://jamsql.com/alternatives/postgis-viewer/): View PostGIS geometry & geography on a map from a desktop SQL client — vs pgAdmin's Geometry Viewer, DBeaver's spatial viewer, and QGIS
- [View SQL Server geometry on a map](https://jamsql.com/alternatives/view-sql-server-geometry-on-a-map/): Cross-platform viewer for SQL Server geometry/geography — the SSMS Spatial-results experience on Mac and Linux too, plus spatial filters and layers
- [vs DBeaver](https://jamsql.com/alternatives/dbeaver/): Free DBeaver alternative — Apple Silicon native binary, no JVM dependency, AI agents via local MCP
- [vs DataGrip](https://jamsql.com/alternatives/datagrip/): Free DataGrip alternative — no JetBrains account, no JVM dependency, plus AI agents via local MCP
- [vs HeidiSQL](https://jamsql.com/alternatives/heidisql/): HeidiSQL alternative for Mac and Linux (HeidiSQL is Windows-only); free, AI-native, multi-engine
- [vs Navicat](https://jamsql.com/alternatives/navicat/): Free Navicat alternative for Mac, Linux, and Windows — same engines, plus AI agents via local MCP
- [vs TablePlus](https://jamsql.com/alternatives/tableplus/): Free TablePlus alternative — execution plans, schema compare, charting, AI agents, no row limit
- [vs Beekeeper Studio](https://jamsql.com/alternatives/beekeeper-studio/): Free Beekeeper Studio alternative — adds execution plans, schema/data compare, charting, AI agents
- [vs DbVisualizer](https://jamsql.com/alternatives/dbvisualizer/): Free DbVisualizer alternative — no JVM dependency, plus AI agents via local MCP
- [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/): Best Oracle database client / GUI / IDE comparison — Jam SQL Studio (no Oracle Client / Thin driver), SQL Developer, Toad, DBeaver, DataGrip, Navicat
- [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/): Free replacement after the Feb 28, 2026 retirement — SQL notebooks, execution plans, schema compare, AI agents
- [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/): Best SQL client comparison for Windows — Jam SQL Studio vs SSMS, DBeaver, DataGrip, HeidiSQL; Windows Auth, Entra ID, replaces Azure Data Studio post-Feb-2026
- [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/): Best free cross-platform SQL IDE for PostgreSQL and SQL Server (with MySQL and Oracle support too)
- [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/): Best PostgreSQL GUI / client / IDE comparison — Jam SQL Studio, pgAdmin, DBeaver, DataGrip, TablePlus; free for Mac (Apple Silicon), Windows, Linux
- [Best MySQL Client](https://jamsql.com/alternatives/best-mysql-client/): Best MySQL / MariaDB GUI / client / IDE comparison — Jam SQL Studio (Apple Silicon native, native ENUM dropdowns, schema compare, AI MCP), MySQL Workbench, DBeaver, DataGrip, TablePlus
- [MySQL Workbench Alternative](https://jamsql.com/alternatives/mysql-workbench/): Head-to-head vs Oracle's MySQL Workbench 8.0.47 — six engines, MCP agent access, data compare vs Workbench's EER modeling, server administration, migration wizard and GPL commercial use
- [Best Schema & Data Compare Tool](https://jamsql.com/alternatives/best-schema-compare-tool/): Schema and data compare tools compared — Redgate SQL Compare, dbForge, ApexSQL Diff, DBeaver, Jam SQL Studio; engines, platforms, pricing, and the free options, each claim sourced and checked August 2026
- [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 Studio alternatives compared (free, cross-platform — covers Mac and Linux)
- [DBeaver Version Control](https://jamsql.com/alternatives/dbeaver-version-control/): How DBeaver version control (Team-menu Git on projects) works vs Jam's Database Blueprint — schema as a folder of .sql files with a built-in Git panel
- [DataGrip Version Control](https://jamsql.com/alternatives/datagrip-version-control/): How DataGrip version control (bundled Git + DDL data sources) works vs Jam's Database Blueprint two-way schema-folder sync
- [Azure Data Studio SQL Database Projects](https://jamsql.com/alternatives/azure-data-studio-sql-database-projects/): How ADS SQL Database Projects (.sqlproj / dacpac) work vs Jam's Database Blueprint folder-of-.sql-files approach
- [SQL Server Source Control](https://jamsql.com/alternatives/sql-server-source-control/): SQL Server source control compared — SSDT / SQL Database Projects, Redgate (EOL 2025), Flyway vs Jam's Database Blueprint
- [Navicat Version Control](https://jamsql.com/alternatives/navicat-version-control/): How Navicat version control (export SQL, commit in an external client) works vs Jam's built-in Git panel + Database Blueprint

## 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/): Free PostgreSQL client for Mac (Apple Silicon native), Windows, and Linux — EXPLAIN ANALYZE visualizer, schema compare
- [MySQL Client](https://jamsql.com/databases/mysql/): Free MySQL and MariaDB client for Mac (Apple Silicon native), Windows, and Linux — IntelliSense, session browser, performance dashboard
- [Oracle Client](https://jamsql.com/databases/oracle/): Oracle database GUI for Mac, Windows & Linux
- [SQLite Client](https://jamsql.com/databases/sqlite/): Free SQLite GUI for Mac, Windows & Linux — open .db files, edit tables, diff two files, map spatial data
- [Azure Data Explorer Client](https://jamsql.com/databases/azure-data-explorer/): Cross-platform Kusto/KQL IDE — clusters, App Insights & Log Analytics proxies, | render charts, KQL notebooks

## Blog

### JSON in Relational Databases (series)

- [JSON in Relational Databases: 5 Engines Compared (2026)](https://jamsql.com/blog/json-in-relational-databases-compared/): Pillar — PostgreSQL, MySQL, SQL Server, Oracle, SQLite JSON support side-by-side, including "do you still need MongoDB" decision matrix
- [PostgreSQL JSON and JSONB: Complete Guide](https://jamsql.com/blog/postgresql-json-jsonb-complete-guide/): json vs jsonb, GIN indexes, SQL/JSON path language (12), JSON_TABLE/JSON_VALUE/JSON_QUERY/JSON_EXISTS (17)
- [MySQL JSON Column Guide](https://jamsql.com/blog/mysql-json-column-guide/): JSON_VALUE vs JSON_EXTRACT, multi-valued indexes (8.0.17+), JSON_TABLE, when MySQL replaces MongoDB
- [SQL Server JSON Support](https://jamsql.com/blog/sql-server-json-support-guide/): OPENJSON, native JSON type (GA on Azure SQL, labelled preview on SQL Server 2025), CREATE JSON INDEX (preview, offline-only), JSON_PATH_EXISTS, JSON_OBJECTAGG/JSON_ARRAYAGG
- [Oracle JSON Guide: 12c to 26ai](https://jamsql.com/blog/oracle-json-support-guide/): JSON_VALUE, JSON_TABLE, IS JSON, native JSON type (21c+), MongoDB-wire-compatible Database API for MongoDB (23ai/26ai)
- [SQLite JSON: json1 as a Document Store](https://jamsql.com/blog/sqlite-json-support-guide/): json1 default since 3.38, -> and ->> operators, JSONB binary (3.45+), generated-column indexes
- [Migrate From MongoDB to Postgres, MySQL, SQL Server, Oracle, or SQLite (2026)](https://jamsql.com/blog/migrate-from-mongodb-to-relational/): Schema mapping, BSON-to-JSON, dual writes / CDC, 7-step migration plan with engine-by-engine playbooks
- [MongoDB Alternatives in 2026](https://jamsql.com/blog/mongodb-alternatives-2026/): Ranked alternatives — Postgres jsonb, Oracle 26ai Mongo API, MySQL, SQL Server, SQLite, FerretDB, AWS DocumentDB, ScyllaDB — with comparison matrix

### Migration

- [Migrate SQL Server to PostgreSQL](https://jamsql.com/blog/2026-06-13-migrate-sql-server-to-postgresql/): MSSQL→Postgres table migration — preview translated DDL, copy schema + data with value coercion; full type-mapping table; procedural bodies stay manual
- [Migrate MySQL to PostgreSQL](https://jamsql.com/blog/2026-06-14-migrate-mysql-to-postgresql/): MySQL/MariaDB→Postgres table migration — tinyint(1)→boolean, datetime→timestamp, AUTO_INCREMENT→IDENTITY, unsigned widening, ENUM/SET carried verbatim+warning; full type table
- [Migrate Oracle to PostgreSQL](https://jamsql.com/blog/2026-06-14-migrate-oracle-to-postgresql/): Oracle→Postgres table migration — VARCHAR2→varchar, NUMBER→numeric/int by precision, DATE→timestamp (Oracle DATE carries time-of-day), CLOB→text, RAW/BLOB→bytea; PL/SQL is a manual port
- [Migrate SQL Server to MySQL](https://jamsql.com/blog/2026-06-14-migrate-sql-server-to-mysql/): MSSQL→MySQL table migration — bit→tinyint(1), uniqueidentifier→char(36), money→decimal(19,4), datetime2→datetime, datetimeoffset→timestamp (tz dropped), IDENTITY→AUTO_INCREMENT
- [SQL Server ↔ PostgreSQL Data Type Mapping (both directions)](https://jamsql.com/blog/2026-06-13-mssql-to-postgresql-data-type-mapping/): Complete MSSQL↔Postgres type reference — bit→boolean, nvarchar→varchar, datetime2→timestamp, uniqueidentifier→uuid, plus the edge cases
- [Convert SQL Server Stored Procedures to PostgreSQL](https://jamsql.com/blog/2026-06-14-convert-sql-server-stored-procedures-to-postgresql/): Worked T-SQL procedure → PL/pgSQL function — params, SELECT INTO, SCOPE_IDENTITY()→RETURNING, result sets; verified on PostgreSQL 16
- [Convert SQL Server Triggers to PostgreSQL](https://jamsql.com/blog/2026-06-14-convert-sql-server-triggers-to-postgresql/): INSERTED/DELETED→NEW/OLD, the separate trigger function, row vs statement level with transition tables; verified on PostgreSQL 16
- [T-SQL to PostgreSQL Function Cheat Sheet](https://jamsql.com/blog/2026-06-14-t-sql-to-postgresql-function-cheat-sheet/): Every common T-SQL built-in → Postgres equivalent, plus the five silent breakers; checked against PostgreSQL 16

### Other

- [What's New in Oracle 26ai (and Where 23ai Went)](https://jamsql.com/blog/2026-08-27-whats-new-oracle-26ai/): Oracle AI Database 26ai explained — 23ai renamed via RU 23.26.0 (Oct 2025), no upgrade needed, 24/25 skipped; genuinely new: CREATE ASSERTION, QUALIFY, Select AI everywhere, Deep Data Security, post-quantum crypto, DATEDIFF/DATEADD, vector-index maturation; what's really 23ai (VECTOR, duality views, BOOLEAN); support clocks (19c to 2029, 21c to Jul 2027, 26ai to Dec 2031) and thin-driver compatibility
- [SQL Server Connection Errors We Actually See, and How to Fix Each One](https://jamsql.com/blog/2026-08-27-sql-server-connection-errors/): Deep troubleshooting for Login failed 18456 (state codes, ELOGIN/4060 trap), pre-login handshake / TLS cert failures, Connection Timeout Expired vs ECONNREFUSED, semaphore timeout (Windows error 121), pool exhaustion — plus the half-open-connection pool stall that looks like a query timeout and the bounded-validation fix from 1.4.23
- [Where Every SQL Client Stores Your Saved Connections](https://jamsql.com/blog/2026-08-27-where-sql-clients-store-connections/): Code-verified per-OS paths and formats for the connection stores of SSMS (UserSettings.xml + RegSrvr.xml), Azure Data Studio, DBeaver, VS Code mssql/pgsql, MySQL Workbench, TablePlus, ODBC DSNs, and Oracle SQL Developer — how each protects passwords (DPAPI, OS keychain, app-bundled AES) and how to move them
- [How to Import Excel into a SQL Database: 3 Ways](https://jamsql.com/blog/2026-08-25-import-excel-into-sql-database/): xlsx → SQL Server/PostgreSQL/MySQL three ways — browser converter, desktop import wizard, native bulk loaders (OPENROWSET + ACE, BULK INSERT/bcp, COPY vs \copy + HEADER MATCH/FORCE_NULL, LOAD DATA LOCAL + local_infile), plus the Excel-side traps (leading zeros, serial dates, 15-digit rounding, CSV encoding)
- [Query Azure Data Explorer, App Insights & Azure Monitor From the Desktop](https://jamsql.com/blog/2026-07-09-query-azure-data-explorer-app-insights-desktop/): Launch of the ADX/Kusto engine — KQL with schema-aware IntelliSense, Entra ID sign-in, App Insights/Log Analytics proxies, Browse Azure picker, | render charts, ADS import; read-only by design
- [Map Geometry & Geography Columns on Every SQL Engine](https://jamsql.com/blog/2026-07-11-postgis-spatial-support/): Launch of spatial support in 1.4.15 — per-engine decode (EWKB / WKB / CLR / SDO / SpatiaLite+GPKG), peek maps, a Query Editor Map view, Table Explorer spatial filters, a layered Spatial Explorer, curve support
- [SQL/PGQ in Practice: GRAPH_TABLE on Oracle and PostgreSQL 19](https://jamsql.com/blog/2026-07-11-sql-pgq-graph-table-oracle-postgresql/): SQL:2023 property graphs hands-on — CREATE PROPERTY GRAPH + GRAPH_TABLE examples, live-tested Oracle 23ai dialect limits with exact ORA- codes, PostgreSQL 19 beta's fixed-length v1, the NJS-098 colon-label trap
- [What's New in SQL Server 2025](https://jamsql.com/blog/2026-08-25-whats-new-sql-server-2025/): SQL Server 2025 (17.x), GA 2025-11-18 — native binary JSON type (GA on Azure SQL, still labelled preview on-prem, no flag needed), JSON index / .modify() / JSON_CONTAINS / JSON aggregates all preview on-prem, VECTOR(n) capped at 1998 float32 dimensions (GA), VECTOR_DISTANCE metrics, CREATE EXTERNAL MODEL / AI_GENERATE_EMBEDDINGS, REGEXP_ functions, optimized locking, edition changes, and flag-gated vs merely-labelled preview
- [What's New in MySQL 26.7 (and Why There's No 9.8)](https://jamsql.com/blog/2026-08-22-whats-new-mysql-26-7/): MySQL 26.7.0 (2026-07-28), the first calendar-versioned Innovation release — CalVer YY.M.P, Change Stream Applier, Thread Pool in Community, post-quantum TLS, 9.7 LTS upgrade path, and the explain_json_format_version=2 plan-shape change
- [What's New in PostgreSQL 19 (And a GUI That Supports It)](https://jamsql.com/blog/whats-new-postgresql-19/): PostgreSQL 19 (beta) feature by feature — SQL/PGQ, REPACK, DDL functions, jsonpath additions, partition MERGE/SPLIT — and where Jam SQL Studio surfaces each, version-gated
- [Oracle on Apple Silicon Without Instant Client](https://jamsql.com/blog/2026-07-07-oracle-apple-silicon-no-instant-client/): Connect to Oracle from an Apple Silicon Mac with no Instant Client and no Rosetta — node-oracledb Thin mode; honest Thick-mode limits and when you still need SQL*Plus
- [Filter JSON Columns Across 5 SQL Engines](https://jamsql.com/blog/2026-05-20-filter-json-columns-sql/): Hands-on tour — JSONPath sub-operators, peek popover for path discovery, declared-on-text validity guards, loose FKs and enums on JSON paths
- [Database Blueprint: a Git-versioned folder of .sql files in sync with your database](https://jamsql.com/blog/2026-05-23-database-blueprint/): Materialize a database as per-object .sql files — refresh, preview, three-way merge, apply back via Schema Compare, built-in Git panel
- [Polymorphic Foreign Keys in SQL](https://jamsql.com/blog/2026-05-20-polymorphic-loose-foreign-keys/): Source-filter scoping for Rails / Django / Laravel polymorphic associations and soft-delete-aware references — without a real FK
- [Show Names Instead of Foreign-Key IDs](https://jamsql.com/blog/2026-08-29-lookup-enums-reference-tables/): FK columns render the referenced row's name next to the key — per-column lookup enums, reference tables marked once, on-demand names for big tables, and MCP agents that read and (with approval) declare the metadata
- [Enum Columns Dropdown Filter](https://jamsql.com/blog/2026-05-15-enum-columns/): Declare VARCHAR/INT columns as enums — values from MySQL ENUM, Postgres pg_enum, CHECK constraints, or sampled DISTINCT
- [Azure Data Studio Migration Guide](https://jamsql.com/blog/azure-data-studio-retiring-migration-guide/): How to migrate from Azure Data Studio in 2026 — step-by-step (export connections, move SQL files, pick a replacement, verify)
- [SSMS Alternatives for Mac](https://jamsql.com/blog/ssms-alternatives-mac/): SSMS for Mac — best SQL Server Management Studio alternatives, compared head-to-head
- [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

## Free Tools

- [Free SQL Tools hub](https://jamsql.com/tools/): Free in-browser SQL developer tools (all client-side, no signup)
- [SQLite Playground](https://jamsql.com/tools/sqlite-playground/): Run SQL in the browser on a preloaded Chinook sample database — SQLite 3.49 via WebAssembly, no signup or install
- [SQL Formatter](https://jamsql.com/tools/sql-formatter/): Dialect-aware formatter for T-SQL, PostgreSQL, MySQL, PL/SQL, SQLite
- [CSV to SQL Converter](https://jamsql.com/tools/csv-to-sql/): CSV/TSV to INSERT statements or CREATE TABLE with inferred types
- [Excel to SQL Converter](https://jamsql.com/tools/excel-to-sql/): Upload an .xlsx workbook, get INSERT statements or CREATE TABLE with inferred types and a sheet picker
- [CSV to JSON Converter](https://jamsql.com/tools/csv-to-json/): CSV/TSV to a pretty-printed JSON array or NDJSON, with per-column type inference
- [Connection String Converter](https://jamsql.com/tools/connection-string-converter/): Parse and convert ADO.NET, JDBC, URL-style, and libpq connection strings
- [SQL IN Clause Generator](https://jamsql.com/tools/sql-in-clause-generator/): Turn a pasted list into a quoted, escaped IN (...) list
- [SQL Data Type Converter](https://jamsql.com/tools/sql-data-type-converter/): Type mappings across SQL Server, PostgreSQL, MySQL, Oracle, SQLite
- [WKT / GeoJSON Viewer](https://jamsql.com/tools/wkt-viewer/): Paste WKT or GeoJSON, see the geometry on a map, read bounding box and centroid, convert WKT ⇄ GeoJSON — all client-side

## 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 SQL under a permission policy** against MSSQL, PostgreSQL, MySQL, MariaDB, Oracle (12.2+, 19c, 21c, 23ai), SQLite, or Azure SQL. Jam SQL Studio's MCP server executes no queries by default. The developer can allow read-only (SELECT-class) queries, or enable Confirm mode — globally or per connection — where each write or DDL statement runs only after they approve it in an in-app dialog (unanswered requests are denied automatically).
- **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 reach the database from outside the developer's machine — the MCP server is bound to `127.0.0.1` only, with no public endpoint to attack.

## 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/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>.

- [Pricing](https://jamsql.com/pricing/): Free Personal tier exact caps, what Pro unlocks, and Pro pricing ($9.99/mo or $99/yr) with a full comparison table and FAQ

## Contact

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