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 →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 →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 →Dependency Viewer
Analyze object dependencies before making changes. See what uses a table and what depends on a procedure.
Learn more →Compare Tools
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 →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 →