OpenSkillIndex ← back to search

claude-code development

Claude-skill-registry architecting-database-schema

Defines schema, attributes, indexes, and enums for Tourly collections. Use when setting up the database in Appwrite.

install

source · Clone the upstream repo

git clone https://github.com/majiayu000/claude-skill-registry

Claude Code · Install into ~/.claude/skills/

T=$(mktemp -d) && git clone --depth=1 https://github.com/majiayu000/claude-skill-registry "$T" && mkdir -p ~/.claude/skills && cp -r "$T/skills/data/architecting-database-schema" ~/.claude/skills/majiayu000-claude-skill-registry-architecting-database-schema && rm -rf "$T"

manifest: skills/data/architecting-database-schema/SKILL.md

tags

#database #schema #appwrite #typescript #data-modeling #indexes

source content

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.