> ## Documentation Index > Fetch the complete documentation index at: https://ngquct-docs-fix-500-query-results.mintlify.site/llms.txt > Use this file to discover all available pages before exploring further. # Features Overview > Every feature page, grouped the way the sidebar groups them First time here: [Quick Start](/quickstart) gets you from install to a query without a database server of your own, using the bundled Chinook sample. ## Start here Homebrew or DMG, on macOS 14.0+. Connect and run a query, sample database included. Import from TablePlus, Sequel Ace, DBeaver, and others. Licensing, privacy, offline use, coverage. Symptom-first checks for launch, connect, and save failures. ## Connections Create, organize, and switch connections. Paste a URL, get a connection. Reach a database behind a bastion, no `ssh` binary needed. Reusable SSH tunnel configurations. Encrypted connections, per-engine defaults, certificate verification. Export and import connection definitions. A connection from the settings in a project's config files. ## Databases Every engine, and where its driver comes from. Drivers, import and export formats, and themes from the registry. ## Write SQL Highlighting, multi-statement execution, formatting. Schema-aware completions from cached column metadata. `:name` placeholders filled in a panel, run as prepared statements. Motions, operators, text objects, and macros in the editor. SQLite FTS5-backed history with full-text search. Which of your statements are slow and which repeat. Starter feature. Collapse statements, CTEs, subqueries and `BEGIN` blocks from the gutter. Open a `.sql` file as a query tab and save back to it. ## Browse and edit data Inline editing, sorting, filtering, undo. Per-column filters, presets, persisted per table. Stage edits, preview SQL, save or discard. JSON, PHP serialized, and binary viewers, plus row details. Edit CSV and TSV files without importing them. Result tabs, pinning, the row cap, and what a failed statement shows. ## Schema and server Alter columns, indexes, foreign keys, primary keys. Truncate, drop, maintenance, views, databases. Visualize tables and foreign keys. Inspect query plans as a tree. Live server stats and activity. Users, roles, and privileges on MySQL and PostgreSQL. ## Import and export CSV, JSON, SQL dumps in and out. pg\_dump and pg\_restore for PostgreSQL and Redshift. ## AI Chat, inline suggestions, explain, optimize, and fix-error. Expose TablePro to Claude and other MCP clients. URL scheme, MCP, and pairing for other apps. Search connections, run queries, focus tabs. `tablepro://` URLs to open connections, tables, and queries. ## Around the app A tab strip per connection, in one window. Every connection and database you have open, one click away. Fuzzy search over tables, databases, and saved queries. Pin tables, save queries, link a folder of `.sql` files. Every default binding, and how to rebind it. ## Sync and licensing Connections, favorites, and settings across Macs. Resume the active connection or table on another device. License keys, tiers, offline validation. Share one license, manage seats, invite codes. ## Customization Every tab, its controls, and their defaults. Themes, fonts, colors, connection colors. Editor toggles, Vim mode, indentation. Page size, result cap, JSON viewer, history. ## iPhone and iPad Browse, query, and edit rows on a synced connection list. ## Security and privacy Every outbound request and where its off switch is. Prompt before destructive statements on production. The open source libraries in the app, and their licenses.