json-server

Runs with a single command like `npx json-server db.json`, creating full CRUD endpoints without writing any server code, as shown in the README's usage example.

Supports advanced filtering, sorting, pagination, and complex queries through URL parameters, such as `?views:gt=100` and `_where` for JSON-based conditions, detailed in the query params section.

Handles relational data with embedding using `_embed`, allowing for nested resources like including comments with posts, demonstrated in the routes and query examples.

Can serve static files from a public directory, making it easy to host frontend assets alongside the mock API, as mentioned in the static files section.