{"repo":"ayoub3bidi/mercury","free":true,"listed":false,"github":"https://github.com/ayoub3bidi/mercury","clone":"git clone https://github.com/ayoub3bidi/mercury.git","description":"FastAPI + PostgreSQL boilerplate with Auth, Docker, and Flyway DB Migrations built-in.","language":"Python","stars":29,"topics":["docker","fastapi","postgresql","redis","flywaydb","sqlalchemy"],"license":"MIT","category":"databases-storage","readme_excerpt":"Mercury Start your Backend project faster than ever Solar Stack — scaffold a customized copy with one command: see the ecosystem map Table of content Introduction Docker Hub image Setup Test the API Test the database How to add new SQL migrations Integration and Unit Testing Linter Security Scan Introduction Mercury is a simple and reliable boilerplate that anyone can use from beginners to experts (no deep bullsh t). This project uses: - Basic OAuth2 authentication, utilizing the FastAPI security module. It also supports user authentication via Google integration. - PostgreSQL as its main database, Redis for caching, and flyway for database migration. - Unit and integration tests. - Security scanner (Bandit). Docker Hub image A pre-built API image is published on Docker Hub and updated on each release: - Repository: ayoub3bidi/mercury Use it alongside your own Postgres, Redis, and Flyway setup, or clone this repo and run the full stack with docker compose (see Setup). Project architecture Setup Prerequisites - docker Environment variables This will create a .env file in your project locally. Run the containers Default admin account Migrations seed one admin user so you can try the API and admin routes right away: Email Password ----------------- ----------- test@admin.com Cloud.456 Get a JWT by calling POST /v1/token with form body username=test@admin.com and password=Cloud.456 , then use the returned access token as Authorization: Bearer for admin endpoints. Change or remove","default_branch":null,"files":null,"tree":[],"storefront":"/r/ayoub3bidi","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/ayoub3bidi/mercury/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}