Guides: sensitive data, AI agents and LLM-generated SQL

Step-by-step guides with real SQL: masking data in PostgreSQL, MySQL and MariaDB, connecting an AI agent to a database and validating the SQL an LLM generates. Each guide cites the official docs and says what was tested.

GuideFor searches like
Data masking for databases: native options and the proxy approach
Static vs. dynamic masking, when you need it, and how the native options compare with masking at a proxy.
data masking, dynamic data masking, database data masking
  ↳ PostgreSQL data masking: views, the anon extension, RLS and a proxy
Views and column privileges, postgresql_anonymizer 3.3, RLS and pg_dump, with tested SQL, and masking at the proxy.
postgresql data masking, postgres data masking, data masking in postgresql
  ↳ MySQL data masking: Enterprise functions, views, generated columns and a proxy
Enterprise masking functions and 9.7 masking policies, what works in Community (views, column privileges, generated columns) and masking at the proxy.
mysql data masking, mysql dynamic data masking, mysql data masking example
  ↳ MariaDB data masking: the MaxScale filter, views and a proxy
No native masking in MariaDB Server: the MaxScale masking filter and its licence, views and column privileges tested on 11.4, and masking at the proxy.
mariadb data masking, maxscale masking
How to connect AI agents to databases: 5 ways, step by step
Connection string, read-only role, an MCP server, the Vericto proxy and check_sql: when to use each, the setup and what can go wrong.
connecting ai agents to databases, connect ai agent to database, mcp database server
Text-to-SQL with LLMs: how it works and how to validate the SQL before it runs
Schema, prompt and few-shot; the typical failures of generated SQL; and how to validate it before it runs.
text to sql llm, llm sql generation, text-to-sql injection

For each risky statement on its own, see the rule pages; for what to do after data was deleted, the incident pages.