Documentation
Learn how to use Jam SQL Studio for database management, schema compare, data compare, execution plan analysis, AI integrations, and more.
Getting Started
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 →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 →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 →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 →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 →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 →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 before the Feb 2026 retirement.
Learn more →Export ADS Connections
Export saved Azure Data Studio connections from your settings.json and import them into Jam SQL Studio.
Learn more →