YAPI - Yaml API. Just a small project I use to create APIs automatically by specifying the endpoints in a YAML file, in small IoT/automation/DS projects.
The heavy lifting is done by FastAPI.
The generated endpoints are simply used to get or store data in any SQL database. A simple SQLite database can be used (as in the example), but a cloud-managed database is also a good idea :)
The example in houses.yaml generates the following API: