PostgreSQL
The PostgreSQL connector lets you query your database in plain language in the anymize chat, by default without any change to the data.
4 Min
What you can do with it
You ask the question, the assistant builds the query. For that it sees the schema, can have queries explained and inspect the database state, such as missing indexes. That is the connector for anyone who has a specialist app without a usable report, but access to the database behind it.
- “How many issues were closed last quarter per department?”
- “Which tables are there, and how are they related?”
- “Why is this report so slow?”
- “Show me the ten oldest open entries.”
Which details do you need?
PostgreSQL has no API key. anymize needs the classic connection fields, each separately and not as a connection string.
- Host: the database server, reachable from outside over HTTPS-capable networks.
- Port: usually 5432, unless your IT specifies otherwise.
- Database: the database name, not the cluster.
- User and password: best a dedicated user for reading only.
- TLS stays on unless your provider expressly requires something else.
The exact values sit with your IT, in the managed-service portal or in the cloud database's connection info. anymize stores them encrypted.
How to connect PostgreSQL
You enter the connection details separately, not as a ready-made connection string. That is on purpose: in such a string parameters can be hidden that redirect the connection setup.
- 01In your database, best create a dedicated user for reading only.
- 02In anymize open Apps, then Connectors, and search for PostgreSQL.
- 03Enter host, port, database, user and password. The encrypted connection (TLS) stays on unless your provider expressly requires something else.
- 04For “Which SQL statements are allowed?” choose Read only. That is the default.
- 05Connect. The credentials are stored encrypted.
If the database is not reachable, it is usually host, port or the TLS setting. If sign-in is rejected, check user and password. anymize rejects some addresses on principle so a connection does not point into an internal network.
Can the AI change my database?
Not in the default. “Read only” allows SELECT, schema queries, EXPLAIN and analyses, nothing else. Writing statements are rejected before they reach the database.
| Setting | What is allowed |
|---|---|
| Read only (default) | SELECT, schema queries, EXPLAIN, analyses. No changes. |
| Read and write | Additionally INSERT, UPDATE, DELETE and structure commands such as CREATE or DROP. |
Because the second setting is possible, the tile says “read and write”. If you turn it on, the assistant asks before every changing instruction and shows you first what it wants to run. The calmer path is still via a database user who may only read anyway.
What is anonymized
Values from your tables go through the same anonymization as everything else: names, addresses, dates of birth, customer numbers and bank details are replaced by placeholders before a result goes to an AI model. Numbers and structures stay so the analysis is correct.