RESTful SQL Database API

I need a clean, well-structured RESTful API that talks directly to a SQL backend (MySQL or PostgreSQL—happy to choose whichever fits your stack best). The job is straightforward: design and build the endpoints, wire them up to the database, and return predictable JSON responses.

The API must cover CRUD operations, include basic token-based authentication, and come with concise Swagger/OpenAPI documentation so I can hand it to front-end devs without extra explanation. Please pay attention to performance (proper indexing, pagination, sensible error handling) and keep the codebase organized for easy future extension.

Deliverables
• Source code with clear project structure
• SQL migration/seed scripts
• Postman or curl examples for every endpoint
• Swagger/OpenAPI spec file
• Brief README explaining setup and deployment steps

I will spin up a fresh server for testing, so aim for environment variables to handle secrets and connection strings. Once the API passes functional testing and the documentation looks good, we are done.