# MySQL integration

> Connect to a MySQL database to query, insert, update, and delete rows using SQL.

- Authentication: apiKey

## Tools (10)

- **Count Rows**: Count the number of rows in a table, optionally with filtering conditions.
- **Custom Query**: Execute any arbitrary SQL statement including JOINs, aggregations, subqueries, and DDL.
- **Delete Row**: Delete one or more rows from a table.
- **Find Row**: Find a single row by a unique identifier or condition.
- **Insert Row**: Insert a new row into a table.
- **List Columns**: Retrieve column definitions for a specific table using information_schema.
- **List Tables**: Retrieve all tables in the connected MySQL database using information_schema.
- **Select Rows**: Query rows from a table with optional filtering, sorting, and pagination.
- **Update Row**: Update one or more existing rows in a table.
- **Upsert Row**: Insert a row or update it if a duplicate key already exists (ON DUPLICATE KEY UPDATE).

## Related prompts

- [Weekly at-risk customer re-engagement from MySQL to Gmail and HubSpot](https://www.generalinput.com/prompts/weekly-at-risk-customer-re-engagement-from-mysql-to-gmail-and-hubspot.md)
- [Daily failed payment recovery from MySQL to HubSpot and Slack](https://www.generalinput.com/prompts/daily-failed-payment-recovery-from-mysql-to-hubspot-and-slack.md)
- [Daily MySQL low-stock restock digest in Slack and Asana](https://www.generalinput.com/prompts/daily-mysql-low-stock-restock-digest-in-slack-and-asana.md)
- [SQL Crafter: draft, explain, and review queries from your schema](https://www.generalinput.com/prompts/sql-crafter-draft-explain-and-review-queries-from-your-schema.md)
- [Daily business KPI digest from MySQL to Slack](https://www.generalinput.com/prompts/daily-business-kpi-digest-from-mysql-to-slack.md)

Connect MySQL in General Input: https://www.generalinput.com/apps/mysql