Build it
What do you want MySQL and UK Police to do together?
Describe it and your agent reads both APIs, builds the automation, tests every branch and ships it. The list below is what exists today, not the limit.
Ask the assistant
You'll sign in before anything runs. What you typed comes with you.
Or work from Claude Code
Install the APIANT plugin for Claude Code and build, edit, test and read run history from your terminal. Every plan gets this, including free, and it spends no assistant credits.
Connect Claude CodeEverything your agent can do with MySQL and UK Police
Triggers and actions 4 triggers ยท 26 actions
Trigger
New or Updated RowTriggers when a new row is added or modified.
- New or Updated Row (Custom Query)
Fires for each new or changed row returned by a SELECT statement you write against the connected MySQL database.
- New Row
Triggers when you add a new row.
- New Table
Fires when a new table appears in the connected MySQL database.
- Add Row
Adds a new row.
- Delete Row
Delete the rows in a table whose chosen column equals a value.
- Find Row
Finds a row in a table via a lookup column.
- Find Rows via Custom Query
Run an author-written SELECT against the connected MySQL database and return every row it produced. Mirrors PostgreSQL 715ae2ac, SQL Server 8e0bbb5d and Oracle 2c308e4d; MySQL placeholder style is ?.
- Find Row via Custom Query
Runs a SELECT statement you write against the connected MySQL database and returns the first row it matches.
- Update Row
Updates an existing row.
Action
Find crimes at location/crimes-at-location - crimes that occurred at a specific location (location_id or lat/lng), optional date
- Find crimes with no location
/crimes-no-location - crimes for a category/force with no location, by month
- Find neighbourhood by location
/locate-neighbourhood - locate the neighbourhood policing team responsible for a lat/lng point
- Find stop and searches at location
/stops-at-location - stop and search incidents at a specific location_id, optional date
- Find stop and searches by area
/stops-street/all - stop and search incidents within a 1 mile radius of a point or custom polygon, optional date
- Find stop and searches by force
/stops-force - stop and search incidents for a specific force, by month
- Find stop and searches with no location
/stops-no-location - stop and search incidents for a force with no location, by month
- Find street level crimes
/crimes-street/all-crime - crimes within a 1 mile radius of a point or custom polygon, optional date
- Find street level outcomes
/outcomes-at-location - outcomes (case results) within a 1 mile radius of a point or custom polygon, optional date
- Get force
/forces/{force_id} - details for a specific police force
- Get last updated date
/crime-last-updated - date the crime data was last updated
- Get neighbourhood
/{force_id}/{neighbourhood_id} - details for a specific neighbourhood
- Get neighbourhood boundary
/{force_id}/{neighbourhood_id}/boundary - list of lat/lng points defining a neighbourhood boundary
- Get outcomes for crime
/outcomes-for-crime/{persistent_id} - outcomes for a specific crime by its persistent id
- List forces
/forces - list all UK police forces (id + name)
- List force senior officers
/forces/{force_id}/people - list senior officers for a specific force
- List neighbourhood events
/{force_id}/{neighbourhood_id}/events - upcoming events for a neighbourhood
- List neighbourhood priorities
/{force_id}/{neighbourhood_id}/priorities - policing priorities for a neighbourhood
- List neighbourhoods
/{force_id}/neighbourhoods - list neighbourhoods for a force
- List neighbourhood team
/{force_id}/{neighbourhood_id}/people - list of members of a neighbourhood policing team
No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.
Each app on its own
Reviews