Appwrite Backend Skill

Patterns + best practices for Appwrite BaaS. Dart, Python, TypeScript.

Disclaimer: Unofficial community resource. Not affiliated/endorsed/sponsored by Appwrite. "Appwrite" trademark of Appwrite Ltd.

Installation

npx skills add https://github.com/sgaabdu4/appwrite-backend --skill appwrite-backend

What's Included

Skill gives AI agents Appwrite dev guidance:

Core Coverage

• TablesDB — CRUD, queries, relationships, transactions, bulk ops
• Authentication — OAuth, email/password, phone, JWT, MFA, sessions
• Storage — uploads, previews, transforms, file tokens
• Functions — cold start opt, event triggers, domain grouping
• Realtime — WebSocket subs, channels, server-side filters
• Messaging — push, email, SMS

Key Patterns

• TablesDB API (Collections API deprecated 1.8.0)
• Atomic operators, race-free updates
• Cursor pagination, perf
• Query.select() relationship expansion
• Type-safe SDK gen appwrite generate
• Official SDK packages only; raw Appwrite HTTP is a violation
• Direct CLI safety routing before every Appwrite CLI command or failure
• Production schema guard: live inventory + baseline completeness before push
• Production migration sequence: expand → resumable data/ACL backfill → compatible function → contract → exact read-back
• Self-hosted Appwrite 1.9.x SDK pins: dart_appwrite: 25.1.0, Flutter appwrite: 25.2.0, node-appwrite: 26.2.0, web appwrite: 26.1.0, Python appwrite: 21.0.0, CLI 22.4.0

Reference Files

Topic	File
Schema & Columns	schema-management.md
Query Optimization	query-optimization.md
Atomic Operators	atomic-operators.md
Relationships	relationships.md
Transactions	transactions.md
Production Migrations	production-migrations.md
Bulk Operations	bulk-operations.md
Authentication	authentication.md
Functions	functions.md
Realtime	realtime.md
Performance	performance.md
Error Handling	error-handling.md
CLI + Schema Safety	appwrite-cli.md

Full list → SKILL.md.

Compatible Agents

• Claude Code
• Cursor
• Windsurf
• Any agent on Agent Skills standard

Usage

Auto-activates when:

• Mention Appwrite, TablesDB, Appwrite SDK
• Work Appwrite auth/storage/functions
• Ask BaaS patterns

Codex explicit invocation:

$appwrite-backend

Contributing

PRs welcome:

1. Fork repo
2. Feature branch (git checkout -b feature/add-new-pattern)
3. Match existing doc style
4. Submit PR

Guidelines

• skills/appwrite-backend/SKILL.md <500 lines
• Detail patterns → skills/appwrite-backend/references/
• Code examples: Dart, Python, TypeScript
• Test Appwrite 1.9+

License

MIT — see LICENSE

Resources

• Appwrite Documentation
• Appwrite API Reference
• Appwrite SDKs