> ## 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.
# Autocomplete
> Schema-aware SQL autocomplete for keywords, tables, columns, and functions
# SQL Autocomplete
Autocomplete suggests keywords, tables, columns, and functions based on where your cursor is and what tables are in scope.
Suggestions appear as you type, from the first character, and after `.` or a space, with a 50ms debounce. There is no minimum prefix. With nothing typed yet, the popup stays hidden in clauses where listing everything is noise (for example after a comma in a SELECT list); it still opens automatically after FROM, JOIN, ON, and other clauses where browsing helps.
| Key | Action |
| ---------------- | -------------------------------------------------- |
| `Ctrl+Space` | Open the popup anywhere, even with an empty prefix |
| `Up` `Down` | Move through suggestions |
| `Return` / `Tab` | Accept the selected suggestion |
| `Escape` | Dismiss and keep typing |
## Completion Types
### SQL Keywords
```sql theme={null}
SEL| -- SELECT
FROM users WH| -- WHERE
SELECT * FROM users WHERE name LIKE '%test%' ORD| -- ORDER BY
```
### Table Names
Tables appear after FROM, JOIN, INSERT INTO, and similar keywords:
```sql theme={null}
SELECT * FROM | -- All tables
SELECT * FROM us| -- Tables starting with "us": users, user_roles
SELECT * FROM a JOIN b ON a.id = b.id JOIN | -- All tables, even after an ON condition
```
The clause is detected at the cursor, so a second or third JOIN suggests tables even when an ON condition comes before it. In a table position, tables lead the list ahead of keywords.
### Column Names
Columns are suggested in SELECT, WHERE, ORDER BY, GROUP BY, and other column contexts.
If a FROM clause exists anywhere in the statement (even after the cursor), columns come from those tables. If no FROM clause exists yet, columns from all cached tables appear as fallback; ambiguous names are qualified: `users.id`, `orders.id`.
```sql theme={null}
SELECT na| -- Columns matching "na" from all cached tables
SELECT | FROM users -- Columns from users
SELECT u.| FROM users u -- Columns from users via alias
SELECT * FROM users WHERE | -- Columns from users
```
#### Alias Resolution
Type an alias followed by `.` to see that table's columns:
```sql theme={null}
SELECT
u.| -- id, name, email, created_at (from users)
FROM users u
JOIN orders o ON u.id = o.| -- id, user_id, total (from orders)
```
#### Derived Tables and CTEs
An alias for a subquery (derived table) or a `WITH` table completes the columns that subquery's SELECT list produces, including `AS` renames:
```sql theme={null}
SELECT ahs.| -- country, avg_score
FROM happiness_scores hs
LEFT JOIN (
SELECT country, AVG(score) AS avg_score
FROM happiness_scores
GROUP BY country
) ahs ON hs.country = ahs.country
WITH totals AS (
SELECT region, SUM(amount) AS total FROM sales GROUP BY region
)
SELECT t.| FROM totals t -- region, total
```
Explicit (`AS name`), bare (`country`), and qualified (`t.col`) columns resolve. A `SELECT *` subquery and unaliased expressions like `AVG(score)` have no name to suggest, so they are skipped.
### Functions
SQL functions appear in SELECT, WHERE, and expression contexts:
```sql theme={null}
SELECT | -- COUNT, SUM, AVG, MAX, MIN, etc.
SELECT COUNT(| -- Columns and *
WHERE date_column > | -- NOW(), CURRENT_DATE, etc.
```
Functions from the connection's SQL dialect (e.g. `CONVERT_TIMEZONE` on Snowflake, `SAFE_CAST` on BigQuery) appear alongside the common SQL functions.
### Favorite Keywords
Favorites you've assigned a keyword to (DB-stored or linked-file `@keyword` frontmatter) appear in the popup as a top-priority match. Type the keyword, accept the suggestion, and the favorite's full SQL replaces the keyword inline. A `;;` in the favorite's SQL sets where the cursor lands after expansion. See [Favorites](/features/favorites#cursor-placement) for how to assign keywords and place the marker.
### Schema Names
For databases with multiple schemas (PostgreSQL):
```sql theme={null}
SELECT * FROM | -- public, schema1, schema2
SELECT * FROM public.| -- Tables in public schema
```
Schema-qualified names like `public.users` resolve in FROM, JOIN, UPDATE, INSERT INTO, and CREATE INDEX.
For databases organized as database, schema, table (Snowflake, BigQuery), every segment completes. Tables of schemas you haven't opened in the sidebar are fetched on demand:
```sql theme={null}
SELECT * FROM ANALYTICS_| -- databases
SELECT * FROM ANALYTICS_PROD.| -- schemas
SELECT * FROM ANALYTICS_PROD.DBT_MARTS.| -- tables in that schema
SELECT * FROM ANALYTICS_PROD.DBT_MARTS.ORDERS o WHERE o.| -- columns
```
## Schema Cache
On connection, TablePro fetches table names and loads columns in the background. The column cache holds up to 50 tables with LRU eviction. There is no time-based expiry: cached columns stay until you switch databases or refresh the connection. A failed schema load waits 30 seconds before retrying, to avoid hammering the server.
After external schema changes (migrations, CLI work), right-click the connection and select **Refresh** to reload.
## Performance
Works on files of any size, including multi-megabyte dumps. For files over 500 KB, only a \~10 KB window around the cursor is analyzed.