> ## Documentation Index
> Fetch the complete documentation index at: https://ngquct-worktree-statusbar-redesign.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Features Overview

> Index of TablePro features grouped by editor, AI, views, data management, workflow, security, sync, and extensibility.

# Features

Every feature in TablePro, grouped so you can jump straight to what you need.

TablePro opens with a sidebar-style welcome window, in the style of the Xcode launcher. Saved connections and groups sit in the sidebar. Search is in the window toolbar (`Cmd+F` to focus). A bundled Chinook sample database opens with one click on first launch. Reset it any time from **File > Reset Sample Database**.

## Editor & Data

<CardGroup cols={2}>
  <Card title="SQL Editor" icon="code" href="/features/sql-editor">
    Tree-sitter highlighting, multi-statement execution, formatting.
  </Card>

  <Card title="Data Grid" icon="table" href="/features/data-grid">
    Inline editing, sorting, filtering, change tracking with undo.
  </Card>

  <Card title="Table Structure" icon="layer-group" href="/features/table-structure">
    Alter columns, indexes, foreign keys, primary keys.
  </Card>

  <Card title="Autocomplete" icon="wand-magic-sparkles" href="/features/autocomplete">
    Schema-aware completions backed by cached column metadata.
  </Card>

  <Card title="Vim Mode" icon="keyboard" href="/features/vim-mode">
    Modal editing in the SQL editor with Normal, Insert, and Visual modes.
  </Card>
</CardGroup>

## AI

<CardGroup cols={2}>
  <Card title="AI Assistant" icon="sparkles" href="/features/ai-assistant">
    Chat, inline suggestions, explain, optimize, and fix-error.
  </Card>

  <Card title="MCP Server" icon="plug" href="/features/mcp">
    Expose TablePro to Claude and other MCP clients.
  </Card>

  <Card title="External API" icon="bolt" href="/external-api">
    URL scheme, MCP, and pairing for Raycast, Cursor, Claude Desktop.
  </Card>

  <Card title="Raycast Extension" icon="magnifying-glass" href="/external-api/raycast">
    Search connections, run queries, focus tabs from Raycast.
  </Card>
</CardGroup>

## Views

<CardGroup cols={2}>
  <Card title="ER Diagram" icon="diagram-project" href="/features/er-diagram">
    Visualize tables and foreign keys.
  </Card>

  <Card title="EXPLAIN Visualization" icon="chart-network" href="/features/explain-visualization">
    Inspect query plans as a tree.
  </Card>

  <Card title="JSON Viewer" icon="brackets-curly" href="/features/json-viewer">
    Text and tree views for JSON cells, with pop-out window.
  </Card>

  <Card title="Server Dashboard" icon="gauge" href="/features/server-dashboard">
    Live server stats and activity.
  </Card>
</CardGroup>

## Data Management

<CardGroup cols={2}>
  <Card title="Import & Export" icon="file-export" href="/features/import-export">
    CSV, JSON, SQL dumps in and out.
  </Card>

  <Card title="Backup & Restore" icon="floppy-disk" href="/features/backup-restore">
    pg\_dump and pg\_restore for PostgreSQL and Redshift.
  </Card>

  <Card title="Change Tracking" icon="pen-to-square" href="/features/change-tracking">
    Stage edits, preview SQL, save or discard.
  </Card>

  <Card title="Filtering" icon="filter" href="/features/filtering">
    Per-column filters, presets, persisted per table.
  </Card>

  <Card title="Table Operations" icon="table-cells" href="/features/table-operations">
    Truncate, drop, rename, duplicate, copy DDL.
  </Card>
</CardGroup>

## Workflow

<CardGroup cols={2}>
  <Card title="Tabs" icon="window-restore" href="/features/tabs">
    Native macOS window tabs per connection.
  </Card>

  <Card title="Query History" icon="clock-rotate-left" href="/features/query-history">
    SQLite FTS5-backed history with full-text search.
  </Card>

  <Card title="Favorites" icon="star" href="/features/favorites">
    Pin tables and save reusable queries.
  </Card>

  <Card title="Keyboard Shortcuts" icon="keyboard" href="/features/keyboard-shortcuts">
    Full shortcut reference.
  </Card>

  <Card title="URL Scheme" icon="link" href="/external-api/url-scheme">
    `tablepro://` URLs to open connections, tables, and queries.
  </Card>
</CardGroup>

## Security & Sharing

<CardGroup cols={2}>
  <Card title="Safe Mode" icon="shield-halved" href="/features/safe-mode">
    Prompt before destructive statements on production.
  </Card>

  <Card title="SSH Profiles" icon="user-lock" href="/features/ssh-profiles">
    Reusable SSH tunnel configurations.
  </Card>

  <Card title="Connection Sharing" icon="share-nodes" href="/features/connection-sharing">
    Export and import connection definitions.
  </Card>
</CardGroup>

## Sync

<CardGroup cols={2}>
  <Card title="iCloud Sync" icon="cloud" href="/features/icloud-sync">
    Sync connections, favorites, and settings across Macs.
  </Card>

  <Card title="Handoff" icon="arrow-right-arrow-left" href="/features/handoff">
    Resume the active connection or table on another Mac.
  </Card>
</CardGroup>

## Extensibility

<CardGroup cols={2}>
  <Card title="Plugins" icon="puzzle-piece" href="/features/plugins">
    Install database driver plugins from the registry.
  </Card>
</CardGroup>
