Integration
Connect MySQL to Hong Kong Obervatory
When something happens in MySQL, your agent does the next thing in Hong Kong Obervatory. Describe it in plain language and the automation is built, tested on every branch and kept running.
Build it
What do you want MySQL and Hong Kong Obervatory 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 Hong Kong Obervatory
Triggers and actions 4 triggers ยท 19 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
Convert Gregorian date to lunar dateConvert a Gregorian calendar date to its lunar calendar year and date. GET lunardate.php?date=.
- Get 9-day weather forecast
Get the 9-day weather forecast including daily temperature, humidity, wind and rain probability. GET weather.php?dataType=fnd.
- Get current weather report
Get the current weather report: temperature, humidity, rainfall, UV index, lightning and warning messages. GET weather.php?dataType=rhrread.
- Get daily maximum temperature
Get daily maximum air temperature records for a station and period. GET opendata.php?dataType=CLMMAXT.
- Get daily mean temperature
Get daily mean air temperature records for a station and period. GET opendata.php?dataType=CLMTEMP.
- Get daily minimum temperature
Get daily minimum air temperature records for a station and period. GET opendata.php?dataType=CLMMINT.
- Get high and low tide times
Get the times and heights of astronomical high and low tides for a station. GET opendata.php?dataType=HLT.
- Get hourly heights of astronomical tides
Get hourly predicted heights of astronomical tides for a station and date. GET opendata.php?dataType=HHOT.
- Get latest 10-minute mean visibility
Get the latest 10-minute mean visibility reading across monitoring stations. GET opendata.php?dataType=LTMV.
- Get lightning count
Get the cloud-to-ground and cloud-to-cloud lightning count for a date. GET opendata.php?dataType=LHL.
- Get moonrise and moonset times
Get times of moonrise, moon transit and moonset for a given date range. GET opendata.php?dataType=MRS.
- Get sunrise and sunset times
Get times of sunrise, sun transit and sunset for a given date range. GET opendata.php?dataType=SRS.
- Get weather and radiation level report
Get the daily weather and ambient gamma radiation level report. GET opendata.php?dataType=RYES.
No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.