Jam SQL Studio

https://jamsql.com/docs
Admin
Jam SQL Studio is a database management tool and IDE supporting SQL Server, PostgreSQL, MySQL,...
Tokens:214,602
Snippets:1,817
Trust Score:6.7
Update:3 weeks ago
Show doc for...
Tokens:
Raw
### KQL Command Examples

Source: https://jamsql.com/docs/kusto-kql

Examples of administrative commands that can be executed alongside standard queries.

```kql
.show tables
```

```kql
.show version
```

--------------------------------

### Install Claude Code and Codex CLI

Source: https://jamsql.com/docs/ai-integrations-mcp

Run either or both commands to install the AI agents. Jam SQL Studio auto-detects whichever CLIs are on your machine.

```bash
npm i -g @anthropic-ai/claude-code   # Claude Code
npm i -g @openai/codex               # Codex CLI
```

--------------------------------

### Jam SQL CLI commands for status, connections, queries, and MCP

Source: https://jamsql.com/docs/ai-integrations-mcp

A set of shell commands for the Jam SQL CLI. Use 'jam-sql doctor' to check installation and pairing, 'jam-sql status' for pairing and app status, 'jam-sql launch' to start the app, 'jam-sql connections' to list saved connections, 'jam-sql query' to execute a query, 'jam-sql tools' and 'jam-sql resources' to list MCP tools and resources, 'jam-sql call' to invoke an MCP tool, 'jam-sql read' to read an MCP resource, and 'jam-sql unpair' to remove stored credentials.

```shell
# Check installation and pairing status
jam-sql doctor

# Show pairing + app status
jam-sql status

# Launch the app if not running
jam-sql launch

# List saved connections
jam-sql connections

# Execute a query
jam-sql query -c production "SELECT * FROM users LIMIT 5"

# List available MCP tools and resources
jam-sql tools
jam-sql resources

# Call any MCP tool directly
jam-sql call ui_open_tab '{"type": "query"}'

# Read an MCP resource
jam-sql read sql-studio://context/tabs

# Remove stored credentials
jam-sql unpair
```

--------------------------------

### Add jam-sql skill to AI agents

Source: https://jamsql.com/docs/ai-integrations-mcp

Run this command to auto-detect and install the jam-sql skill for supported agents like Claude Code, Cursor, Copilot, Codex, Windsurf, and more. The CLI is bundled with the app and installed to your PATH.

```bash
jam-sql add-skill
```

--------------------------------

### Run a simple query to list tables

Source: https://jamsql.com/docs/getting-started

Example SQL query to select the top 10 tables from the system catalog, ordered by name. Use this in the query editor after opening a new query tab.

```sql
SELECT TOP 10 * FROM sys.tables ORDER BY name;
```
Tokens:
Raw