# Commands

## Connection Management

| Command | Description | Example |
|---------|-------------|---------|
| `init <name> <type> <conn-string> [schema]` | Create new database connection | `squix create mydb postgres "postgresql://..."` |
| `use/switch <name>` | Switch to a different connection | `squix use production` |
| `status` | Show current active connection | `squix status` |
| `list connections` | List all configured connections | `squix list connections` |

## Query Operations

| Command | Description | Example |
|---------|-------------|---------|
| `add <name> [sql]` | Add a new saved query | `squix add users "SELECT * FROM users"` |
| `remove <name\|id>` | Remove a saved query | `squix remove users` or `squix remove 3` |
| `list queries` | List all saved queries | `squix list queries` |
| `list queries --oneline` | lists each query in one line | `squix list -o` |
| `list queries <searchterm>` | lists queries containing search term | `squix list employees` |
| `run <name\|id\|sql>` | Execute a query | `squix run users` or `squix run 2` |
| `run` | Create and run a new query | `squix run` |
| `run --edit` | Edit query before running | `squix run users --edit` |
| `run --last`, `-l` | Re-run last executed query | `squix run --last` |
| `run --param` | run with named params | `squix run --name Squix` |
| `shell` | Interactive query REPL (alias: `repl`) | `squix shell` |


## Database Exploration

| Command | Description | Example |
|---------|-------------|---------|
| `explore` | List all tables and views in multi-column format | `squix explore` |
| `explore <table> [-l N]` | Query a table with optional row limit | `squix explore employees --limit 100` |
| `explore <file.csv>` | View a local CSV file in the results view (read-only) | `squix explore sales.csv` |
| `explain <table> [-d N] [-c]` | Visualize foreign key relationships | `squix explain employees --depth 2` |
| `tables` | List all tables in using the results view, access with Enter| `squix tables` |
| `example [path] [--force]` | Create a sample office-themed SQLite database to try squix | `squix example` |

## Configuration

| Command | Description | Example |
|---------|-------------|---------|
| `config` | Edit main configuration file | `squix config` |
| `edit` | Edit all queries for current connection | `squix edit` |
| `edit <name\|id>` | Edit a single named query | `squix edit 3` |
| `remove --connection <name>` | Remove a db connection | `squix remove --conection dev4`` |
| `help [command]` | Show help information | `squix help run` |