architecting-database-schema
Defines schema, attributes, indexes, and enums for Tourly collections. Use when setting up the database in Appwrite.
Best use case
architecting-database-schema is best used when you need a repeatable AI agent workflow instead of a one-off prompt.
Defines schema, attributes, indexes, and enums for Tourly collections. Use when setting up the database in Appwrite.
Teams using architecting-database-schema should expect a more consistent output, faster repeated execution, less prompt rewriting.
When to use this skill
- You want a reusable workflow that can be run more than once with consistent structure.
When not to use this skill
- You only need a quick one-off answer and do not need a reusable workflow.
- You cannot install or maintain the underlying files, dependencies, or repository context.
Installation
Claude Code / Cursor / Codex
Manual Installation
- Download SKILL.md from GitHub
- Place it in
.claude/skills/architecting-database-schema/SKILL.mdinside your project - Restart your AI agent — it will auto-discover the skill
How architecting-database-schema Compares
| Feature / Agent | architecting-database-schema | Standard Approach |
|---|---|---|
| Platform Support | Not specified | Limited / Varies |
| Context Awareness | High | Baseline |
| Installation Complexity | Unknown | N/A |
Frequently Asked Questions
What does this skill do?
Defines schema, attributes, indexes, and enums for Tourly collections. Use when setting up the database in Appwrite.
Where can I find the source code?
You can find the source code on GitHub using the link provided at the top of the page.
SKILL.md Source
# Database Schema Architecture ## When to use this skill - When creating new collections in the Appwrite Console. - When defining TypeScript interfaces for database documents. ## Schema Definition ### Users (Private Data) - `userId` (string, required) - `name` (string) - `email` (string, required) - `role` (enum: user, admin) ### Tours - `title` (string, required) - `description` (markdown/text) - `location` (string, required) - `price` (float, required) - `images` (string array, storage IDs) - `rating` (float) - `availableDates` (datetime array) ### Bookings - `userId` (string, required) - `tourId` (string, required) - `status` (enum: pending, confirmed, cancelled) - `totalPrice` (float) ## Instructions - **Indexes**: Add indexes for searchable fields like `location` and `price`. - **Permissions**: Ensure "Users" can only read their own bookings.
Related Skills
docker-database
Configure database containers with security, persistence, and health checks
Database Sync
Automate database synchronization, replication, migration, and cross-platform data integration
database-skill
Design and manage relational databases including table creation, migrations, and schema design. Use for database modeling and maintenance.
database-architect
Database design and optimization specialist. Schema design, query optimization, indexing strategies, data modeling, and migration planning for relational and NoSQL databases.
architecting-data
Strategic guidance for designing modern data platforms, covering storage paradigms (data lake, warehouse, lakehouse), modeling approaches (dimensional, normalized, data vault, wide tables), data mesh principles, and medallion architecture patterns. Use when architecting data platforms, choosing between centralized vs decentralized patterns, selecting table formats (Iceberg, Delta Lake), or designing data governance frameworks.
arch-database
DB architecture: relational vs document vs graph vs vector, schema design, indexing, replication, sharding
acsets-algebraic-databases
ACSets (Attributed C-Sets): Algebraic databases as in-memory data structures. Category-theoretic formalism for relational databases generalizing graphs and data frames.
vercel-kv-database-rules
Defines how to interact with Vercel's KV database for storing and retrieving session and application data.
Validate with Database
Connect to live PostgreSQL database to validate schema assumptions, compare pg_dump vs pgschema output, and query system catalogs interactively
sqlmap-database-pentesting
This skill should be used when the user asks to "automate SQL injection testing," "enumerate database structure," "extract database credentials using sqlmap," "dump tables and columns...
Schema Migration
Create safe, zero-downtime schema migrations with rollback procedures
Schema Evolution Impact Analysis
Analyze the impact of model/schema changes on downstream code — affected repositories, services, handlers, tests, and migration requirements