Documentation
Learn how to use Jam SQL Studio for database management, schema compare, data compare, execution plan analysis, AI integrations, and more.
Getting Started
Getting Started
New to Jam SQL Studio? Start here. Install the app, create your first connection, and run your first query.
Get started →Connections
Connect to SQL Server, Azure SQL, PostgreSQL, MySQL, MariaDB, Oracle, SQLite, and Azure Data Explorer. Learn about authentication methods and connection options.
Learn more →Browse Azure
Pick ADX clusters, App Insights, Log Analytics, Azure SQL, and PostgreSQL flexible servers straight from your signed-in Azure account.
Learn more →Core Features
Query Editor
Write and execute SQL queries with IntelliSense, manage transactions, organize scripts, and export results to various formats.
Learn more →Table Explorer
Browse, filter, and edit table data. Sort columns, apply filters, inline edit cells, and export in multiple formats.
Learn more →Data Import
Import CSV, TSV, Excel, or JSON files into a new or existing table across all five engines — with column mapping, row filters, and an error report for invalid rows.
Learn more →JSON Columns
Filter JSON/JSONB by JSONPath across all five engines, declare long-text columns as JSON, peek the JSON shape, and attach loose foreign keys to JSON properties.
Learn more →Table Designer
Create and modify database tables visually. Define columns, set data types, configure keys, and preview DDL scripts.
Learn more →SQL Notebooks
Combine executable SQL cells with Markdown documentation in a Jupyter-style notebook. Shared sessions, inline results, and .ipynb compatibility.
Learn more →PL/SQL Debugger
Step through Oracle PL/SQL code with breakpoints, variable inspection, call stack navigation, and watch expressions. Works on macOS, Windows, and Linux.
Learn more →Package Explorer
Browse and search every Oracle PL/SQL package across all schemas in the selected database. Filter by name or schema without drilling through the Object Explorer tree.
Learn more →Visual Query Editor
Open any SELECT, INSERT, UPDATE, DELETE, or MERGE statement as a structural diagram. Read joins, CTEs, subqueries, and set operators at a glance — and edit round-trip with the Add buttons on each clause card, which write changes back into the SQL buffer.
Learn more →Visual DDL Editor
Edit CREATE/ALTER statements through visual popovers without writing SQL. Add columns, edit constraints, change sequences, and modify routine signatures — every change patches back into the buffer byte-for-byte.
Learn more →Visualization
Schema Overview
Visualize your database schema with an interactive graph. See tables, views, and foreign key relationships at a glance.
Learn more →Execution Plans
Analyze query performance with visual execution plans. Compare plans and identify bottlenecks.
Learn more →SQL Dashboards
Multi-tile dashboards over live SQL — charts, stats, tables, and pivots with auto-refresh, parameters, cross-filtering, and alerts.
Learn more →Charts
Visualize query results as bar charts, line charts, pie charts, and more. Export charts as images.
Learn more →Data Profiling
Inspect column distributions, quartiles, top values, and null counts — inline popover or full workspace tab.
Learn more →Dependency Viewer
Analyze object dependencies before making changes. See what uses a table and what depends on a procedure.
Learn more →Loose Foreign Keys
Declare logical column-to-column references without altering the schema. Get FK navigation, lookup pickers, and inbound related data on legacy databases — and roundtrip via MetaInfo import/export.
Learn more →JSON Columns
Native JSON, CHECK ISJSON / IS JSON / json_valid, and user-declared loose JSON across every engine. JSON-aware operators, path autocomplete, dialect-correct emit, and tree-mode rendering.
Learn more →Enum Columns
Declare a column as an enum and the filter chip's text input becomes a dropdown sourced from MySQL ENUM / Postgres pg_enum, CHECK constraints, or sampled distinct values — capped at 200 with a built-in safety budget.
Learn more →Spatial / PostGIS
Map geometry & geography columns across PostgreSQL/PostGIS, MySQL, SQL Server, Oracle and SQLite — peek maps, a Map results view, a Table Explorer map pane with spatial filters, a Spatial Explorer workspace, and curved-geometry rendering. Basemap on by default.
Learn more →Compare Tools
Schema Compare
Compare database schemas across connections. View DDL differences and generate synchronization scripts.
Learn more →Data Compare
Compare table data between databases. Identify differences and generate sync scripts for rows.
Learn more →Database Blueprint
Blueprint a database to a folder of .sql files. Two-way sync, Git versioning, and three-way merge across linked environments.
Learn more →Data Operations
Backup & Restore
Protect your data with database backups. Support for SQL Server .bak files, BACPAC, and PostgreSQL pg_dump.
Learn more →Clone
Clone databases and tables for testing and development. Copy schema with or without data.
Learn more →Security
Manage database security. Create logins, users, roles, and permissions for SQL Server and PostgreSQL.
Learn more →Database Administration
Session Browser
Monitor active database sessions, view locks and wait events, and kill runaway queries across Oracle, SQL Server, PostgreSQL, and MySQL.
Learn more →Deadlock Analyzer
Open or paste SQL Server deadlock reports (.xdl / XML) and inspect the victim, processes, lock modes and the owner/waiter graph — no connection needed.
Learn more →Query Store
Compare two periods of SQL Server Query Store history with execution-weighted averages, rank candidate regressions and open the stored compiled plans.
Learn more →Performance Dashboard
Real-time performance counters, top SQL, wait statistics, memory usage, and error logs for Oracle, SQL Server, PostgreSQL, and MySQL.
Learn more →Tablespace Manager
Oracle tablespace usage visualization, datafile details, I/O statistics, and undo monitoring with DBA privilege fallback.
Learn more →Filegroup Manager
SQL Server filegroup layout, database file details, I/O statistics, log files, and ALTER DATABASE script generation.
Learn more →Agent Jobs Manager
The first cross-platform GUI for SQL Server Agent. Browse jobs, view history, run and stop jobs, manage operators, alerts, proxies, and error logs.
Learn more →Productivity
Sessions
Save and restore your workspace state. Keep your tabs, queries, and connections between work sessions.
Learn more →Snippets
Use SQL snippets to quickly insert common code patterns. Create custom snippets with tab stops.
Learn more →Scripting
Generate DDL scripts from database objects. Script tables, views, procedures as CREATE, ALTER, or DROP.
Learn more →Keyboard Shortcuts
Complete keyboard shortcuts reference for query execution, navigation, editing, and results management.
Learn more →Command Palette
Fuzzy-search every command, database object, and connection with Cmd+Shift+P. Drill into contextual actions without leaving the keyboard.
Learn more →AI & Integrations
Migration
Cross-Engine Database Migration
Overview of migrating tables and data between SQL Server, PostgreSQL, MySQL, Oracle, and SQLite — how it works and what's manual.
Learn more →T-SQL vs PL/pgSQL
Side-by-side dialect reference for porting SQL Server procedural code to PostgreSQL: variables, control flow, errors, functions.
Learn more →Finish a PostgreSQL Schema
The day-after checklist: port views, procedures, and triggers, resolve warnings, and verify the migrated data.
Learn more →Migrate from Azure Data Studio
Step-by-step guide to migrating your workflows from Azure Data Studio, which Microsoft retired in February 2026.
Learn more →Export ADS Connections
Export saved Azure Data Studio connections from your settings.json and import them into Jam SQL Studio.
Learn more →Roadmap & History
Changelog
Full release history. See what's new in each version: features, improvements, and bug fixes.
View changelog →Next Up
See what's coming next on the roadmap, plus a summary of recently shipped features.
See roadmap →Kusto / KQL
Connect to Azure Data Explorer (Kusto): run KQL with IntelliSense, browse tables read-only, and chart | render results.
Learn more →Azure Storage
Connect to Azure Storage accounts, SAS URLs and Azurite: upload and download blobs and file-share files as background transfers, manage file shares, browse Data Lake (ADLS Gen2) directories and edit their ACLs, work with queue messages, and browse and edit Table entities.
Learn more →