PromptRails
All Integrations
MySQL

MySQL

Databases

Connect MySQL databases for AI-powered querying and data management. Your agents can explore schemas, run queries, and extract insights from your MySQL data.

How to Connect

  1. 1Go to Settings and then Credentials.
  2. 2Add a MySQL connection with your host, port, database, username, and password.
  3. 3Create a Data Source and select the MySQL credential.
  4. 4Add the Data Source to your agent.

Connection Methods

MCP Template (Recommended)

Recommended

Install from the template marketplace. Select an existing credential and your agents can run dynamic SQL queries, list tables, and describe schemas.

  1. 1Create a database credential in Settings → Credentials
  2. 2Go to MCP Templates marketplace
  3. 3Find the MySQL Query template
  4. 4Select your credential from the dropdown
  5. 5Install — your agent can now query the database

Data Source

Create a versioned data source with a fixed query template. Best for controlled, repeatable queries where the SQL is predefined.

  1. 1Create a database credential in Settings → Credentials
  2. 2Go to Data Sources and create a new data source
  3. 3Write your SQL query template with {{ parameter }} placeholders
  4. 4Add the data source as a tool to your agent

Security & SQL Injection Protection

  • All database credentials are encrypted at rest with AES-256-GCM
  • Agent-generated SQL is executed with read-only permissions when possible
  • Query results are truncated at 50,000 rows / 100MB to prevent resource exhaustion
  • Connection details never leave the server — credentials are resolved server-side
  • Use parameterized queries with the params argument to prevent SQL injection
  • LLM Guard content scanning can be enabled to detect prompt injection attempts
  • SSRF protection prevents connections to private/internal network addresses