Question 1

Does TextQL work with MySQL-compatible databases like PlanetScale or Vitess?

Accepted Answer

Yes. TextQL supports any MySQL-compatible database, including PlanetScale, Vitess, MariaDB, TiDB, and Percona Server. Ana generates standard MySQL syntax that works across all these platforms. Specific features like PlanetScale's branching model are compatible — TextQL connects to whichever branch you specify.

Question 2

How does TextQL handle MySQL's different storage engines?

Accepted Answer

TextQL works with any MySQL storage engine that supports SELECT queries — InnoDB, MyISAM, MEMORY, and others. Ana reads table metadata including the engine type and adapts its query optimization accordingly. Foreign key relationships in InnoDB are auto-discovered for more accurate JOIN generation.

Question 3

Can TextQL connect to a MySQL read replica?

Accepted Answer

Yes, and we recommend it for production databases. Simply provide the read replica endpoint instead of the primary. TextQL only runs SELECT queries, so a read replica provides full functionality while keeping your primary instance dedicated to application workloads.

Question 4

What MySQL versions does TextQL support?

Accepted Answer

TextQL supports MySQL 5.7 and above, including MySQL 8.x. It also works with MariaDB 10.3+. Ana detects your server version during connection and adjusts query generation to use only features available in your version — like window functions for MySQL 8.0+.

Question 5

Can I join MySQL data with data from a warehouse?

Accepted Answer

TextQL's multi-source query engine lets you ask questions that span MySQL application data and warehouse analytics from Snowflake, BigQuery, Redshift, or any other connected source. TextQL handles the cross-database joins and returns a unified result set.