Top 3 Python automatic-api Projects

datasette

80 7,248 9.4 Python

An open source multi-tool for exploring and publishing data

Project mention: Not by AI | news.ycombinator.com | 2023-03-16

If anyone doubts that simonw knows Datasette well, I encourage a close examination of this URL: https://github.com/simonw/datasette
sandman2

1 1,924 0.0 Python

Automatically generate a RESTful API service for your legacy database. No code required!

Project mention: Nocodb: Turns Any MySQL, Postgres, SQLite into a Spreadsheet with REST APIs | news.ycombinator.com | 2022-10-04

https://github.com/jeffknupp/sandman2 works with many different backends including sqlite, but postgrest definitely have the auth flow and security model right for these things.
Sonar

www.sonarsource.com
sponsored

Write Clean Python Code. Always.. Sonar helps you commit clean code every time. With over 225 unique rules to find Python bugs, code smells & vulnerabilities, Sonar finds the issues while you focus on the work.
mathesar

34 1,401 9.6 Python

Web application providing an intuitive user experience to databases.

Project mention: Launch HN: Outerbase (YC W23) – A new UI and editor for your database | news.ycombinator.com | 2023-03-16

Mathesar core team member here. I don't want to distract from Outerbase's launch, but if you have time, would you be able to open an issue for the crash at https://github.com/centerofci/mathesar? We're still in alpha and relying on people checking out the project to report problems like these so we can fix them.
Also, relationships without foreign keys is on our roadmap: https://github.com/centerofci/mathesar/discussions/2276

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2023-03-16.