{"id":"efc6f157-ecee-4e6e-b408-108d06821b65","shortId":"R4xfFC","kind":"skill","title":"python-fastapi-development","tagline":"Python FastAPI backend development with async patterns, SQLAlchemy, Pydantic, authentication, and production API patterns.","description":"# Python/FastAPI Development Workflow\n\n## Overview\n\nSpecialized workflow for building production-ready Python backends with FastAPI, featuring async patterns, SQLAlchemy ORM, Pydantic validation, and comprehensive API patterns.\n\n## When to Use This Workflow\n\nUse this workflow when:\n- Building new REST APIs with FastAPI\n- Creating async Python backends\n- Implementing database integration with SQLAlchemy\n- Setting up API authentication\n- Developing microservices\n\n## Workflow Phases\n\n### Phase 1: Project Setup\n\n#### Skills to Invoke\n- `app-builder` - Application scaffolding\n- `python-development-python-scaffold` - Python scaffolding\n- `fastapi-templates` - FastAPI templates\n- `uv-package-manager` - Package management\n\n#### Actions\n1. Set up Python environment (uv/poetry)\n2. Create project structure\n3. Configure FastAPI app\n4. Set up logging\n5. Configure environment variables\n\n#### Copy-Paste Prompts\n```\nUse @fastapi-templates to scaffold a new FastAPI project\n```\n\n```\nUse @python-development-python-scaffold to set up Python project structure\n```\n\n### Phase 2: Database Setup\n\n#### Skills to Invoke\n- `prisma-expert` - Prisma ORM (alternative)\n- `database-design` - Schema design\n- `postgresql` - PostgreSQL setup\n- `pydantic-models-py` - Pydantic models\n\n#### Actions\n1. Design database schema\n2. Set up SQLAlchemy models\n3. Create database connection\n4. Configure migrations (Alembic)\n5. Set up session management\n\n#### Copy-Paste Prompts\n```\nUse @database-design to design PostgreSQL schema\n```\n\n```\nUse @pydantic-models-py to create Pydantic models for API\n```\n\n### Phase 3: API Routes\n\n#### Skills to Invoke\n- `fastapi-router-py` - FastAPI routers\n- `api-design-principles` - API design\n- `api-patterns` - API patterns\n\n#### Actions\n1. Design API endpoints\n2. Create API routers\n3. Implement CRUD operations\n4. Add request validation\n5. Configure response models\n\n#### Copy-Paste Prompts\n```\nUse @fastapi-router-py to create API endpoints with CRUD operations\n```\n\n```\nUse @api-design-principles to design RESTful API\n```\n\n### Phase 4: Authentication\n\n#### Skills to Invoke\n- `auth-implementation-patterns` - Authentication\n- `api-security-best-practices` - API security\n\n#### Actions\n1. Choose auth strategy (JWT, OAuth2)\n2. Implement user registration\n3. Set up login endpoints\n4. Create auth middleware\n5. Add password hashing\n\n#### Copy-Paste Prompts\n```\nUse @auth-implementation-patterns to implement JWT authentication\n```\n\n### Phase 5: Error Handling\n\n#### Skills to Invoke\n- `fastapi-pro` - FastAPI patterns\n- `error-handling-patterns` - Error handling\n\n#### Actions\n1. Create custom exceptions\n2. Set up exception handlers\n3. Implement error responses\n4. Add request logging\n5. Configure error tracking\n\n#### Copy-Paste Prompts\n```\nUse @fastapi-pro to implement comprehensive error handling\n```\n\n### Phase 6: Testing\n\n#### Skills to Invoke\n- `python-testing-patterns` - pytest testing\n- `api-testing-observability-api-mock` - API testing\n\n#### Actions\n1. Set up pytest\n2. Create test fixtures\n3. Write unit tests\n4. Implement integration tests\n5. Configure test database\n\n#### Copy-Paste Prompts\n```\nUse @python-testing-patterns to write pytest tests for FastAPI\n```\n\n### Phase 7: Documentation\n\n#### Skills to Invoke\n- `api-documenter` - API documentation\n- `openapi-spec-generation` - OpenAPI specs\n\n#### Actions\n1. Configure OpenAPI schema\n2. Add endpoint documentation\n3. Create usage examples\n4. Set up API versioning\n5. Generate API docs\n\n#### Copy-Paste Prompts\n```\nUse @api-documenter to generate comprehensive API documentation\n```\n\n### Phase 8: Deployment\n\n#### Skills to Invoke\n- `deployment-engineer` - Deployment\n- `docker-expert` - Containerization\n\n#### Actions\n1. Create Dockerfile\n2. Set up docker-compose\n3. Configure production settings\n4. Set up reverse proxy\n5. Deploy to cloud\n\n#### Copy-Paste Prompts\n```\nUse @docker-expert to containerize FastAPI application\n```\n\n## Technology Stack\n\n| Category | Technology |\n|----------|------------|\n| Framework | FastAPI |\n| Language | Python 3.11+ |\n| ORM | SQLAlchemy 2.0 |\n| Validation | Pydantic v2 |\n| Database | PostgreSQL |\n| Migrations | Alembic |\n| Auth | JWT, OAuth2 |\n| Testing | pytest |\n\n## Quality Gates\n\n- [ ] All tests passing (>80% coverage)\n- [ ] Type checking passes (mypy)\n- [ ] Linting clean (ruff, black)\n- [ ] API documentation complete\n- [ ] Security scan passed\n- [ ] Performance benchmarks met\n\n## Related Workflow Bundles\n\n- `development` - General development\n- `database` - Database operations\n- `security-audit` - Security testing\n- `api-development` - API patterns\n\n## Limitations\n- Use this skill only when the task clearly matches the scope described above.\n- Do not treat the output as a substitute for environment-specific validation, testing, or expert review.\n- Stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.","tags":["python","fastapi","development","antigravity","awesome","skills","sickn33","agent-skills","agentic-skills","ai-agent-skills","ai-agents","ai-coding"],"capabilities":["skill","source-sickn33","skill-python-fastapi-development","topic-agent-skills","topic-agentic-skills","topic-ai-agent-skills","topic-ai-agents","topic-ai-coding","topic-ai-workflows","topic-antigravity","topic-antigravity-skills","topic-claude-code","topic-claude-code-skills","topic-codex-cli","topic-codex-skills"],"categories":["antigravity-awesome-skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/sickn33/antigravity-awesome-skills/python-fastapi-development","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add sickn33/antigravity-awesome-skills","source_repo":"https://github.com/sickn33/antigravity-awesome-skills","install_from":"skills.sh"}},"qualityScore":"0.700","qualityRationale":"deterministic score 0.70 from registry signals: · indexed on github topic:agent-skills · 34616 github stars · SKILL.md body (4,902 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-04-23T00:51:27.016Z","embedding":null,"createdAt":"2026-04-18T21:43:05.247Z","updatedAt":"2026-04-23T00:51:27.016Z","lastSeenAt":"2026-04-23T00:51:27.016Z","tsv":"'1':78,108,184,254,318,373,428,481,530 '2':114,157,188,258,324,377,432,485,533 '2.0':575 '3':118,193,230,262,328,382,436,489,539 '3.11':572 '4':122,197,266,300,333,386,440,493,543 '5':126,201,270,337,355,390,444,498,548 '6':408 '7':464 '8':516 '80':593 'action':107,183,253,317,372,427,480,529 'add':267,338,387,486 'alemb':200,582 'altern':168 'api':17,43,57,71,228,231,243,246,249,251,256,260,285,292,298,311,315,420,423,425,470,472,496,500,508,513,603,627,629 'api-design-principl':242,291 'api-develop':626 'api-document':469,507 'api-pattern':248 'api-security-best-practic':310 'api-testing-observability-api-mock':419 'app':85,121 'app-build':84 'applic':87,563 'ask':664 'async':10,35,61 'audit':623 'auth':306,320,335,347,583 'auth-implementation-pattern':305,346 'authent':14,72,301,309,353 'backend':7,31,63 'benchmark':610 'best':313 'black':602 'boundari':672 'build':26,54 'builder':86 'bundl':614 'categori':566 'check':596 'choos':319 'clarif':666 'clean':600 'clear':639 'cloud':551 'complet':605 'compos':538 'comprehens':42,404,512 'configur':119,127,198,271,391,445,482,540 'connect':196 'container':528,561 'copi':131,207,275,342,395,449,503,553 'copy-past':130,206,274,341,394,448,502,552 'coverag':594 'creat':60,115,194,224,259,284,334,374,433,490,531 'criteria':675 'crud':264,288 'custom':375 'databas':65,158,170,186,195,212,447,579,618,619 'database-design':169,211 'deploy':517,522,524,549 'deployment-engin':521 'describ':643 'design':171,173,185,213,215,244,247,255,293,296 'develop':4,8,20,73,91,147,615,617,628 'doc':501 'docker':526,537,558 'docker-compos':536 'docker-expert':525,557 'dockerfil':532 'document':465,471,473,488,509,514,604 'endpoint':257,286,332,487 'engin':523 'environ':112,128,655 'environment-specif':654 'error':356,367,370,384,392,405 'error-handling-pattern':366 'exampl':492 'except':376,380 'expert':165,527,559,660 'fastapi':3,6,33,59,97,99,120,136,142,237,240,280,362,364,400,462,562,569 'fastapi-pro':361,399 'fastapi-router-pi':236,279 'fastapi-templ':96,135 'featur':34 'fixtur':435 'framework':568 'gate':589 'general':616 'generat':477,499,511 'handl':357,368,371,406 'handler':381 'hash':340 'implement':64,263,307,325,348,351,383,403,441 'input':669 'integr':66,442 'invok':83,162,235,304,360,412,468,520 'jwt':322,352,584 'languag':570 'limit':631 'lint':599 'log':125,389 'login':331 'manag':104,106,205 'match':640 'met':611 'microservic':74 'middlewar':336 'migrat':199,581 'miss':677 'mock':424 'model':179,182,192,221,226,273 'mypi':598 'new':55,141 'oauth2':323,585 'observ':422 'openapi':475,478,483 'openapi-spec-gener':474 'oper':265,289,620 'orm':38,167,573 'output':649 'overview':22 'packag':103,105 'pass':592,597,608 'password':339 'past':132,208,276,343,396,450,504,554 'pattern':11,18,36,44,250,252,308,349,365,369,416,456,630 'perform':609 'permiss':670 'phase':76,77,156,229,299,354,407,463,515 'postgresql':174,175,216,580 'practic':314 'principl':245,294 'prisma':164,166 'prisma-expert':163 'pro':363,401 'product':16,28,541 'production-readi':27 'project':79,116,143,154 'prompt':133,209,277,344,397,451,505,555 'proxi':547 'py':180,222,239,282 'pydant':13,39,178,181,220,225,577 'pydantic-models-pi':177,219 'pytest':417,431,459,587 'python':2,5,30,62,90,92,94,111,146,148,153,414,454,571 'python-development-python-scaffold':89,145 'python-fastapi-develop':1 'python-testing-pattern':413,453 'python/fastapi':19 'qualiti':588 'readi':29 'registr':327 'relat':612 'request':268,388 'requir':668 'respons':272,385 'rest':56,297 'revers':546 'review':661 'rout':232 'router':238,241,261,281 'ruff':601 'safeti':671 'scaffold':88,93,95,139,149 'scan':607 'schema':172,187,217,484 'scope':642 'secur':312,316,606,622,624 'security-audit':621 'session':204 'set':69,109,123,151,189,202,329,378,429,494,534,542,544 'setup':80,159,176 'skill':81,160,233,302,358,410,466,518,634 'skill-python-fastapi-development' 'source-sickn33' 'spec':476,479 'special':23 'specif':656 'sqlalchemi':12,37,68,191,574 'stack':565 'stop':662 'strategi':321 'structur':117,155 'substitut':652 'success':674 'task':638 'technolog':564,567 'templat':98,100,137 'test':409,415,418,421,426,434,439,443,446,455,460,586,591,625,658 'topic-agent-skills' 'topic-agentic-skills' 'topic-ai-agent-skills' 'topic-ai-agents' 'topic-ai-coding' 'topic-ai-workflows' 'topic-antigravity' 'topic-antigravity-skills' 'topic-claude-code' 'topic-claude-code-skills' 'topic-codex-cli' 'topic-codex-skills' 'track':393 'treat':647 'type':595 'unit':438 'usag':491 'use':47,50,134,144,210,218,278,290,345,398,452,506,556,632 'user':326 'uv':102 'uv-package-manag':101 'uv/poetry':113 'v2':578 'valid':40,269,576,657 'variabl':129 'version':497 'workflow':21,24,49,52,75,613 'write':437,458","prices":[{"id":"b14d41cd-e0a5-42bc-84e4-7af7437ebe6d","listingId":"efc6f157-ecee-4e6e-b408-108d06821b65","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"sickn33","category":"antigravity-awesome-skills","install_from":"skills.sh"},"createdAt":"2026-04-18T21:43:05.247Z"}],"sources":[{"listingId":"efc6f157-ecee-4e6e-b408-108d06821b65","source":"github","sourceId":"sickn33/antigravity-awesome-skills/python-fastapi-development","sourceUrl":"https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/python-fastapi-development","isPrimary":false,"firstSeenAt":"2026-04-18T21:43:05.247Z","lastSeenAt":"2026-04-23T00:51:27.016Z"}],"details":{"listingId":"efc6f157-ecee-4e6e-b408-108d06821b65","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"sickn33","slug":"python-fastapi-development","github":{"repo":"sickn33/antigravity-awesome-skills","stars":34616,"topics":["agent-skills","agentic-skills","ai-agent-skills","ai-agents","ai-coding","ai-workflows","antigravity","antigravity-skills","claude-code","claude-code-skills","codex-cli","codex-skills","cursor","cursor-skills","developer-tools","gemini-cli","gemini-skills","kiro","mcp","skill-library"],"license":"mit","html_url":"https://github.com/sickn33/antigravity-awesome-skills","pushed_at":"2026-04-22T06:40:00Z","description":"Installable GitHub library of 1,400+ agentic skills for Claude Code, Cursor, Codex CLI, Gemini CLI, Antigravity, and more. Includes installer CLI, bundles, workflows, and official/community skill collections.","skill_md_sha":"070424bb35f2f04c14bce46aa214b12db37ba93f","skill_md_path":"skills/python-fastapi-development/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/python-fastapi-development"},"layout":"multi","source":"github","category":"antigravity-awesome-skills","frontmatter":{"name":"python-fastapi-development","description":"Python FastAPI backend development with async patterns, SQLAlchemy, Pydantic, authentication, and production API patterns."},"skills_sh_url":"https://skills.sh/sickn33/antigravity-awesome-skills/python-fastapi-development"},"updatedAt":"2026-04-23T00:51:27.016Z"}}