sandman2

Health v2 · maintenance only

Flags: no_releases

Adoption not part of the score

2042 stars · 217 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

sandman2 is a Python library and CLI tool that automatically generates RESTful API services from existing relational databases using SQLAlchemy introspection. Given a database connection string, it launches a REST API with filtering support and an HTML admin interface with no boilerplate code.

Use cases

• expose a legacy database as a REST API
• auto-generate CRUD endpoints from existing tables
• quickly prototype an API over a sqlite database
• add a REST layer to a MySQL or PostgreSQL database without writing code
• browse and edit database contents through an admin interface
• spin up an HTTP API for legacy database-driven systems

When to choose

• you need a REST API over an existing database with minimal effort
• you want zero-boilerplate CRUD endpoints for legacy tables
• you're prototyping and want instant API plus admin UI from a connection string

When to avoid

• you need fine-grained control over API design, validation, or business logic
• you require modern async frameworks or OpenAPI-first workflows
• you need active development and recent maintenance
• you need non-SQLAlchemy-supported datastores

Facets

library · maturity maintenance

api-framework http-server orm database web-development backend databases apis developer-tools python cross-platform rest-api-generation database-introspection sqlalchemy auto-generated-api legacy-databases admin-interface

Member repositories

For agents

markdown · JSON · MCP: product_card(name="jeffknupp/sandman2")