> ## Documentation Index
> Fetch the complete documentation index at: https://ngquct-feat-ai-sql-walkthroughs.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, team and licensing, and extensibility.

# Features

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

TablePro opens with a welcome window: an actions panel on the left (Create Connection, Import from App, Try Sample Database) and your saved connections on the right. Search sits in the connections panel header; press `Cmd+F` to focus it. The sample is a bundled Chinook SQLite database. 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="Query Parameters" icon="sliders" href="/features/query-parameters">
    `:name` placeholders filled in a panel, run as prepared statements.
  </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="Table Operations" icon="table-cells" href="/features/table-operations">
    Truncate, drop, rename, duplicate, copy DDL.
  </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 & Visualization

<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="Cell & Row Viewers" icon="brackets-curly" href="/features/json-viewer">
    JSON, PHP serialized, and binary viewers, per-column display formats, row details inspector.
  </Card>

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

  <Card title="Users & Roles" icon="user-shield" href="/features/users-roles">
    Manage users, roles, and privileges on MySQL and PostgreSQL.
  </Card>
</CardGroup>

## Data Management

<CardGroup cols={2}>
  <Card title="CSV Inspector" icon="file-csv" href="/features/csv-inspector">
    Open and edit CSV and TSV files without importing them.
  </Card>

  <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>
</CardGroup>

## Workflow

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

  <Card title="Quick Switcher" icon="compass" href="/features/quick-switcher">
    Cmd+Shift+O fuzzy search across tables, databases, and saved queries.
  </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="SSL/TLS" icon="certificate" href="/features/ssl">
    Encrypted connections, per-engine defaults, certificate verification.
  </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>

## Team & Licensing

<CardGroup cols={2}>
  <Card title="Team Plan" icon="users" href="/features/team">
    Share one license, manage seats on the web, join with an invite code.
  </Card>

  <Card title="Licensing" icon="key" href="/features/licensing">
    Activate a license key, tier comparison, offline validation.
  </Card>
</CardGroup>

## Extensibility

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