FastAPI Tasks API

A simple CRUD REST API for task management, organized into projects, built with FastAPI and SQLModel.

Tech Stack

• Python 3.14
• FastAPI
• SQLModel (SQLAlchemy + Pydantic)
• SQLite (easily swappable for PostgreSQL in production)
• Alembic (database migrations)
• pydantic-settings (environment configuration)
• pytest (test suite)

Setup

With Docker (recommended)

git clone https://github.com/carlosalaris/fastapi-tasks.git
cd fastapi-tasks
cp .env.example .env # Edit .env with your own SECRET_KEY
docker compose up --build

The API will be available at http://localhost:8000/docs. The database is created automatically on first run and persists across restarts.

Without Docker

git clone https://github.com/carlosalaris/fastapi-tasks.git
cd fastapi-tasks
python -m venv venv
source venv/Scripts/activate  # Windows Git Bash
pip install -r requirements.txt
cp .env.example .env # Edit .env with your own SECRET_KEY
alembic upgrade head # Run database migrations
fastapi dev

API docs: http://localhost:8000/docs

Environment Variables

Variable	Default	Description
SECRET_KEY	(required)	JWT signing secret
DATABASE_URL	sqlite:///./database.db	SQLAlchemy database URL
ALGORITHM	HS256	JWT algorithm
ACCESS_TOKEN_EXPIRE_MINUTES	30	JWT token lifetime in minutes

Tests

pytest

Access model

• Admin can see and manage everything
• Project owner can create, edit, and delete their own projects and manage all tasks inside them, including assigning tasks to other users
• Collaborator (user with tasks assigned in someone else's project) can see the project and their own tasks, and can update their tasks (e.g. mark as completed), but cannot modify the project or other users' tasks
• General user can create, edit, and delete their own tasks
• Reassigning a project transfers the old owner's tasks to the new owner (collaborator tasks stay unchanged)
• Deleting a project deletes all tasks inside it

Endpoints

Auth

Method	Endpoint	Auth	Description
POST	/auth/register	Public	Register a new user
POST	/auth/token	Public	Login and get JWT token

Projects

Method	Endpoint	Auth	Description
GET	/projects	User	List own projects (all if admin)
GET	/projects/{id}	User	Get a single project
POST	/projects	User	Create a project
PATCH	/projects/{id}	User	Update a project
DELETE	/projects/{id}	User	Delete a project

Project filters

Param	Type	Description
user_id	int	Filter by owner (admin only)
name	string	Filter by name
description	string	Filter by description
color	string	Filter by color
sort	string	created_at, updated_at, name, description, color, user_id
order	string	asc, desc
skip	int	Offset (default 0)
limit	int	Max results (default 20)

Tasks

Method	Endpoint	Auth	Description
GET	/tasks	User	List own tasks (all if admin)
GET	/tasks/{id}	User	Get a single task
POST	/tasks	User	Create a task
PATCH	/tasks/{id}	User	Update a task
DELETE	/tasks/{id}	User	Delete a task

Task filters

Param	Type	Description
completed	bool	Filter by status
project_id	int	Filter by project
user_id	int	Filter by assigned user
sort	string	created_at, due_date, title
order	string	asc, desc
skip	int	Offset (default 0)
limit	int	Max results (default 20)

Users

Method	Endpoint	Auth	Description
GET	/users	Admin	List all users
GET	/users/me	User	Get own profile
PATCH	/users/me	User	Update own profile
GET	/users/{id}	Admin	Get a user by ID
POST	/users	Admin	Create a user with role
PATCH	/users/{id}	Admin	Update a user
DELETE	/users/{id}	Admin	Delete a user

User filters

Param	Type	Description
role	string	Filter by role (admin, user)
username	string	Filter by username
sort	string	created_at, updated_at, role
order	string	asc, desc
skip	int	Offset (default 0)
limit	int	Max results (default 20)