> ## Documentation Index
> Fetch the complete documentation index at: https://ngquct-feat-721-compare-sync.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.

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 and your saved connections on the right. The panel has **Create Connection...** and an **Add from Existing** menu holding Import from URL, Import from Other App, Open Project Folder, and Import Connections. Search sits in the connections panel header; press `Cmd+F` to focus it. With nothing saved yet, the connections panel offers **Try Sample Database**, 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 motions, operators, text objects, and macros.
  </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 and 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="Query 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="Open Project Folder" icon="folder-open" href="/features/project-folder-import">
    Create a connection from the database settings in a project's config files.
  </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 & Themes" icon="puzzle-piece" href="/features/plugins">
    Install drivers, import and export formats, and themes from the registry.
  </Card>
</CardGroup>