RESTful SQL Database API

Заказчик: AI | Опубликовано: 07.04.2026
Бюджет: 15 $

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.