MySQL

You ask in normal language, the assistant builds the query and explains it to you on request. For that it sees the tables and their structure. That is the path to reports from a specialist app that itself offers none.

• “How many orders came in last month per region?”
• “Which tables are in this database?”
• “Show me all entries without an assigned customer.”
• “Build me a report of revenue by quarter.”

MySQL and MariaDB have no API key. anymize needs host, port, database, user and password, each separately.

• Host and port: usually port 3306.
• Database: the schema name.
• User and password: ideally a dedicated read-only user.
• Leave TLS on if your provider supports it.

You enter the connection details separately, not as a ready-made connection string. Parameters that redirect the connection setup could be hidden in one, so anymize does not accept them at all.

1. 01In your database, best create a dedicated user for reading only.
2. 02In anymize open Apps, then Connectors, and search for MySQL.
3. 03Enter host, port, database, user and password and leave the encrypted connection (TLS) on.
4. 04For “Which SQL statements are allowed?” choose Read only. That is the default.
5. 05Connect. The credentials are stored encrypted.

Not in the default. With “Read only” anymize checks every statement before it goes to the database and only lets reading ones through. A DELETE or DROP never even arrives.

If you switch to “Read and write”, INSERT, UPDATE, DELETE and structure commands are possible as well. That is why the tile says “read and write”, even if the default is different.

Values from your tables are anonymized before a result goes to an AI model: names, addresses, email addresses, customer numbers and bank details are replaced by placeholders. Numbers and structures stay so the analysis is correct.