Skills
.Work. You
Rest

react-fastapi-sqlite

Community

Ship React + FastAPI CRUD with SQLite

Software Engineering#typescript#react#fastapi#sqlmodel#sqlite#tanstack query#full-stack crud
Authorthistleknot
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Accelerates building a working full-stack CRUD app by providing a proven React (TanStack Query) + FastAPI (SQLModel) + SQLite architecture, including correct data-flow boundaries and cache invalidation patterns so the UI stays consistent.

Core Features & Use Cases

  • Full-stack CRUD scaffold: SQLite persistence via SQLModel tables with FastAPI routers exposing CRUD endpoints.
  • Server-state correctness with TanStack Query: queryOptions for list/detail, plus mutations that invalidate the right query keys after create/update/delete.
  • Clean React architecture: fetch logic stays in api/ and hooks/; pages/ compose hooks; components/ remain pure UI.
  • Fast integration points: a ready-to-run project layout with CORS, axios base URL configuration, and a GET /health endpoint for sanity checks.

Quick Start

Scaffold the backend and frontend with the provided project layout for a React + FastAPI + SQLite app, ensuring TanStack Query hooks invalidate the items cache after mutations.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: react-fastapi-sqlite
Download link: https://github.com/thistleknot/skills/archive/main.zip#react-fastapi-sqlite

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.