## TL;DR

The plural forms compile to invalid VECTOR_KEYS [your value] options instead of index DDL, producing the 1064 error. Rename the keys in __table_args__ to the singular forms; this was fixed upstream in the docs so new copies of the tutorial are correct. The dialect recognizes only the singular keys singlestoredb_vector_key, singlestoredb_multi_value_index, singlestoredb_full_text_index.

## The error

```text
plural table-arg names emit invalid VECTOR_KEYS SQL
```

## Fix

1. The plural forms compile to invalid VECTOR_KEYS [your value] options instead of index DDL, producing the 1064 error.
   Expected: You get the expected result; the problem is gone.
2. Rename the keys in __table_args__ to the singular forms; this was fixed upstream in the docs so new copies of the tutorial are correct.
   Expected: You get the expected result; the problem is gone.
3. Re-run the original operation and confirm the error is gone.
   Expected: no error, normal output.

## When to use

- You hit this exact error with SingleStore SQLAlchemy dialect.
- The symptom matches: plural table-arg names emit invalid VECTOR_KEYS SQL.

## When NOT to use

- A different error message from SingleStore SQLAlchemy dialect; the cause here is specific to this error.
- Unrelated SingleStore SQLAlchemy dialect issues (different feature, different failure).
- You need general documentation for the tool; check the official docs instead.

## Compatibility

Reported against SingleStore SQLAlchemy dialect. Source: https://github.com/singlestore-labs/sqlalchemy-singlestoredb/issues/15.

## Variant phrasings

### plural table-arg names emit invalid VECTOR_KEYS SQL

## Why it happens

Alembic migrations fail with a 1064 syntax error near 'VECTOR_KEYS [your value] The table args used the plural option names from the tutorial.

## Edge cases

- If your error message differs even slightly, this is probably a different issue; search the exact text.
- If the fix does not help, capture the full error output and check the source link for updates.

## Source

https://github.com/singlestore-labs/sqlalchemy-singlestoredb/issues/15