ThatApp supports direct connections to MySQL, PostgreSQL, and MSSQL databases. Connected SQL data is added to your lake and queryable by AVA.

Step 1: Tell AVA you want to connect a database

"I want to connect our MySQL database."

AVA will ask for the connection details one at a time.

Step 2: Provide connection details

AVA will ask for:

  • Database type (MySQL, PostgreSQL, or MSSQL)
  • Host/IP address
  • Port (default: 3306 for MySQL, 5432 for PostgreSQL, 1433 for MSSQL)
  • Database name
  • Username
  • Password

AVA tests the connection before saving any credentials.

Step 3: Choose what to sync

By default, ThatApp will read the table structure and ask which tables you want to include in your lake. You can include all tables or select specific ones.

For large databases, start with the most important tables and add more later.

Step 4: Querying SQL data with AVA

Once connected, AVA can answer questions about your SQL data in plain language:

"How many active customers do we have in the database?" "Show me all orders from last month where the total was over $500."

AVA translates your plain-language question into a SQL query, runs it, and shows you the result.

SQL billing

Each connected SQL database is billed at $10 per month, separate from platform connection fees. SQL records count toward your record storage billing at the standard rate.

Security

ThatApp stores SQL credentials encrypted. The connection uses read-only access where possible — ThatApp will never modify your source database unless you explicitly build an automation that does so.

Related: How to Export Data From Your Lake · How Automations Work