Question 1

Can TextQL handle complex Postgres schemas with many foreign keys?

Accepted Answer

Yes. TextQL auto-discovers all foreign key relationships, constraints, and indexes in your Postgres database. Ana uses these relationships to generate correct multi-table JOINs automatically. Even with highly normalized schemas containing dozens of related tables, Ana traces the join paths needed to answer your question.

Question 2

Does TextQL work with Postgres extensions like PostGIS or pg_trgm?

Accepted Answer

TextQL supports querying tables that use Postgres extensions. Ana can generate queries involving common extension functions when they're relevant to your question. For spatial data (PostGIS) or full-text search (pg_trgm), Ana leverages the appropriate extension-specific SQL syntax.

Question 3

Will TextQL slow down my production database?

Accepted Answer

TextQL is designed to minimize database load. Ana generates efficient queries with appropriate filters and limits. We recommend connecting to a read replica for production databases, which TextQL fully supports. You can also configure query timeout limits to prevent any long-running queries.

Question 4

Can I connect to Postgres through an SSH tunnel?

Accepted Answer

Yes. TextQL supports SSH tunnel connections for databases not exposed to the public internet. Provide your SSH host, port, and key during setup, and TextQL routes the Postgres connection through the tunnel. This is the recommended approach for production databases in private networks.

Question 5

Does TextQL only run read queries?

Accepted Answer

Yes. TextQL exclusively executes SELECT statements. The connection is enforced as read-only at the application level, and we recommend using a database user with SELECT-only privileges as an additional safeguard. Ana will never generate INSERT, UPDATE, DELETE, or DDL statements.