# Jam SQL Studio - Complete Documentation > 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. This file is auto-generated from the Jam SQL Studio documentation pages. For the latest version, visit https://jamsql.com/docs/ --- ## Getting Started Install Jam SQL Studio on macOS, Windows, or Linux. Create your first database connection using SQL Server authentication, Windows authentication, or Microsoft Entra ID. No account required for the free Personal tier. Supported databases: Microsoft SQL Server (including Azure SQL), PostgreSQL (including Amazon RDS), MySQL 5.7+/8.x, MariaDB 10.x/11.x, Oracle Database 11g/12c/19c/21c/23c, and SQLite. Download: https://jamsql.com/#download --- ## Query Editor Write and execute SQL queries with IntelliSense autocomplete. Features include: - Execute all queries (Cmd+E / Ctrl+E) or selected text only - IntelliSense for tables, columns, functions, keywords, and snippets - Multiple result sets with tab navigation - Inline result editing (UPDATE/INSERT/DELETE) - Export results to CSV, JSON, or XLSX - Transaction management: Auto, Manual, and Smart Commit modes - Query history with tab restoration - File-backed tabs that sync to .sql files --- ## Table Explorer Browse and filter table data with an intuitive grid interface: - Column filtering and sorting - Inline cell editing with validation - Foreign key navigation with preview popovers - Row details panel with JSON preview - Data export in multiple formats - Pagination controls --- ## Table Designer Create and modify tables visually: - Add/remove/reorder columns - Set data types, nullability, defaults - Define primary keys and foreign keys - Create indexes and constraints - Generate CREATE TABLE scripts - Engine-aware syntax for MSSQL, PostgreSQL, MySQL --- ## Schema Compare Compare database schemas across connections: - Side-by-side DDL diff view - Select individual changes to include - Generate ALTER/CREATE/DROP sync scripts - Compare tables, views, procedures, functions - Filter by object type or change type --- ## Data Compare Compare table data between databases: - See added, modified, and deleted rows - Generate INSERT/UPDATE/DELETE sync scripts - Compare by primary key or custom key columns - Filter by change type - Export comparison results --- ## Execution Plans Visualize and analyze query execution plans: - Tree view and graph view modes - Operator cost breakdown - Plan comparison side-by-side - Import/export plans (.sqlplan format) - Search and highlight expensive operations - Node detail panel with properties --- ## Schema Overview Interactive graph visualization of your entire database schema: - Tables, views, procedures, and functions as connected nodes - Foreign key relationships rendered as arrows - Dependency arrows between objects - Zoom, pan, and search - Filter by schema or object type --- ## Dependency Viewer Visualize object dependencies: - Tree view and graph view - See what tables, views, and procedures reference each other - Upstream and downstream dependencies - Useful before making schema changes --- ## AI Integrations & MCP Jam SQL Studio supports AI coding assistants in two ways: ### AI Workspace (Inside the App) - Query tabs sync to .sql files - Auto-generated CLAUDE.md context file - Schema export to .schema/ directory - Results history to .history/ directory - Knowledge pack in .knowledge/ directory - Integrated terminal with connection context ### MCP Server (Outside the App) - 13 MCP tools and 9 resources - Localhost-only (127.0.0.1) - Bearer token authentication - Read-only by default - Full audit logging Works with Claude Desktop, Claude Code, OpenCode, Codex CLI, GitHub Copilot, and other AI agents. ### MCP Tools - connections_list: List saved connections (no secrets) - query_execute: Execute read-only SQL queries - ui_open_tab: Open query or table tabs - ui_focus_tab: Switch to a specific tab - ui_set_editor_text: Write SQL to editor - ui_close_tab: Close tabs - ui_lock_tab / ui_unlock_tab: Prevent conflicts - ui_check_abort: Check for user abort requests - table_set_filter: Apply column filters - table_set_sort: Sort by column - table_set_pagination: Navigate pages - table_get_snapshot: Get current table state ### MCP Resources - workspace_snapshot: Active workspace state - connections_snapshot: Connection status - tabs_snapshot: Open tabs and editors - editor_snapshot: Active editor content - results_snapshot: Query results preview - selection_snapshot: Selected explorer item - app_manifest: App version and features - app_capabilities: Supported workflows - app_user_guide: How-to documentation --- ## Connections Manage database connections: - SQL Server authentication, Windows authentication, Microsoft Entra ID (device code flow, MFA-friendly) - PostgreSQL (password, md5, scram-sha-256), MySQL/MariaDB, SQLite (file-based) - Oracle Database (service name or SID, SYSDBA/SYSOPER roles, wallet support) - Persistent token caching - Connection groups and favorites - Azure SQL Database support --- ## Backup & Restore Database backup and restore operations: - Export/import .bacpac files - Create .bak backups for MSSQL - PostgreSQL support via pg_dump and pg_restore - Progress tracking --- ## Charts Create charts from query results: - Bar, line, pie, area, and scatter charts - Configure axes and series - Export as SVG or PNG - Auto-detect chart-friendly result sets --- ## Sessions Session persistence and workspace management: - Auto-save workspace state - Resume with all tabs, connections, and queries - Multiple workspace support --- ## Snippets SQL snippet templates: - Built-in templates for common SQL patterns - Custom snippets per database engine - Trigger snippets via IntelliSense - Parameterized placeholders --- ## Clone Clone databases and tables: - Clone entire databases with one click - Clone individual tables - Copy schema, data, and security objects - Same server or cross-server cloning --- ## Security Security manager: - View and manage database users and roles - Permission management - Login management for SQL Server --- ## Scripting Script generation for database objects: - Generate CREATE, DROP, SELECT, INSERT, UPDATE, DELETE scripts - Tables, views, procedures, and databases - Engine-aware syntax (MSSQL, PostgreSQL, MySQL) - Script to clipboard or new editor tab --- ## PL/SQL Debugger Debug Oracle PL/SQL packages, procedures, and functions cross-platform: - Breakpoints, step over/into/out - Watch expressions and local variable inspection - Call stack navigation - Works on macOS, Windows, and Linux (no Oracle client install required) --- ## Tablespace Manager Oracle tablespace administration: - View tablespaces, datafiles, usage, and autoextend settings - Create, alter, and drop tablespaces - Resize datafiles --- ## Filegroup Manager SQL Server filegroup administration: - View filegroups and files - Create, alter, and drop filegroups - Track file usage and growth --- ## Agent Jobs Manage SQL Server Agent jobs from macOS, Windows, or Linux: - List, enable/disable, start/stop jobs - View job history, schedules, and step details - No SSMS or Windows host required --- ## Session Browser View and manage active database sessions: - List active sessions with CPU, memory, and blocking info - Inspect the currently executing SQL - Kill sessions (with confirmation) --- ## Performance Dashboard Real-time database performance metrics: - Live CPU, memory, I/O, and wait-stat charts - Top queries by cost - Connection and session overview --- ## Keyboard Shortcuts Common shortcuts (macOS / Windows): - Execute query: Cmd+E / Ctrl+E - New query tab: Cmd+N / Ctrl+N - Save: Cmd+S / Ctrl+S - Close tab: Cmd+W / Ctrl+W - Toggle sidebar: Cmd+B / Ctrl+B - Command palette: Cmd+Shift+P / Ctrl+Shift+P - Find/Replace: Cmd+F / Ctrl+F - Comment line: Cmd+/ / Ctrl+/ --- ## Pricing - **Personal (Free)**: Unlimited connections, IntelliSense, query execution, table explorer, basic charting. No account required. - **Pro Monthly ($9.99/mo)**: AI Workspace, execution plans, advanced charting, schema compare, priority support. - **Pro Yearly ($99/yr)**: Same as Pro Monthly, save 17%. - **Enterprise**: Custom pricing, volume licensing, SSO/SAML (coming soon), dedicated account management. All plans include a 14-day free trial of Pro features. --- ## Links - Website: https://jamsql.com/ - Documentation: https://jamsql.com/docs/ - Download: https://jamsql.com/#download - Support: support@jamsql.com