Skip to main content

SQL Database

Connect a SQL database so RunLLM's SRE agent can run read-oriented queries during investigations. Use a read-only database user with the minimum permissions needed for troubleshooting.

The agent can:

  • List tables in the connected database
  • Describe a table’s columns and types
  • Run parameterized SELECT queries (results are capped at 1,000 rows)
ParameterDescription
DialectSQLAlchemy dialect name for your engine (for example, postgresql, mysql, or mssql).
HostDatabase hostname (for example, db.example.com).
PortTCP port (for example, 5432 for PostgreSQL or 3306 for MySQL).
Database NameThe database to connect to.
UsernameDatabase username.
PasswordDatabase password. Stored securely with your tool configuration.

Optional parameters

ParameterDescription
Rules / InstructionsFree-form instructions that guide the agent on how to use this integration (for example, "Read-only; prefer the analytics replica" or "Only query tables under schema app_public").
Read-only credentials

We strongly recommend credentials that can only SELECT (and any minimal grants required for your investigation workflow). Avoid admin or write-capable users.