Supabase Schema From Requirements
jeremylongshore/tons-of-skills-marketplace
Design Supabase Postgres schema from business requirements with migrations, RLS, and types.
Build reactive, type-safe, production-grade backends. An agent skill from waynesutton/markdown-site.
$ npx skills add waynesutton/markdown-site --skill real-time-backend -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install waynesutton/markdown-site real-time-backend --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/waynesutton/markdown-site.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.claude/real-time-backend .claude/skills/real-time-backend && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "real-time-backend" agent skill from https://github.com/waynesutton/markdown-site/tree/main/.claude/real-time-backend into .claude/skills/real-time-backend/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "real-time-backend", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/waynesutton/markdown-site/tree/main/.claude/real-time-backendType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add waynesutton/markdown-site --skill real-time-backend -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install waynesutton/markdown-site real-time-backend --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/waynesutton/markdown-site.git skills-src && mkdir -p .agents/skills && cp -r skills-src/.claude/real-time-backend .agents/skills/real-time-backend && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "real-time-backend" agent skill from https://github.com/waynesutton/markdown-site/tree/main/.claude/real-time-backend into .agents/skills/real-time-backend/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "real-time-backend", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add waynesutton/markdown-site --skill real-time-backend -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install waynesutton/markdown-site real-time-backend --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/waynesutton/markdown-site.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/.claude/real-time-backend .cursor/skills/real-time-backend && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "real-time-backend" agent skill from https://github.com/waynesutton/markdown-site/tree/main/.claude/real-time-backend into .cursor/skills/real-time-backend/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "real-time-backend", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/waynesutton/markdown-site.git --path .claude/real-time-backend--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add waynesutton/markdown-site --skill real-time-backend -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install waynesutton/markdown-site real-time-backend --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/waynesutton/markdown-site.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/.claude/real-time-backend .gemini/skills/real-time-backend && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "real-time-backend" agent skill from https://github.com/waynesutton/markdown-site/tree/main/.claude/real-time-backend into .gemini/skills/real-time-backend/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "real-time-backend", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install waynesutton/markdown-site real-time-backendInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add waynesutton/markdown-site --skill real-time-backend -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/waynesutton/markdown-site.git skills-src && mkdir -p .github/skills && cp -r skills-src/.claude/real-time-backend .github/skills/real-time-backend && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "real-time-backend" agent skill from https://github.com/waynesutton/markdown-site/tree/main/.claude/real-time-backend into .github/skills/real-time-backend/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "real-time-backend", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add waynesutton/markdown-site --skill real-time-backend -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install waynesutton/markdown-site real-time-backend --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/waynesutton/markdown-site.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/.claude/real-time-backend .opencode/skills/real-time-backend && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "real-time-backend" agent skill from https://github.com/waynesutton/markdown-site/tree/main/.claude/real-time-backend into .opencode/skills/real-time-backend/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "real-time-backend", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
real-time-backendBuild reactive, type-safe, production-grade backends. An agent skill from waynesutton/markdown-site.
Real Time Backend is an agent skill from waynesutton/markdown-site. Build reactive, type-safe, production-grade backends. ALWAYS use this skill when the user asks to build, plan, design, or implement backend features, APIs, data models, server logic, database schemas, web apps, full stack apps, or mobile apps. This includes planning and architecture discussions.
Its SKILL.md is about 2.1k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.
It sits in Development, covering Type safety and Database schema design. The repository describes itself as: An open-source publishing framework built for AI agents and developers to ship websites, docs, or blogs. Write markdown, sync from the terminal. Your content is instantly… The licence is MIT.
12 steps, taken from the step headings in SKILL.md.
Read from SKILL.md and the folder at commit 3872c59. It shows what the files ask for, not the result of running them.
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
No scripts in the folder and no shell commands in SKILL.md (its code samples are typescript).
From the folder's file list and the shell code blocks in SKILL.md.
Links to these hosts (documentation or services it may open):
github.comFrom URLs in SKILL.md, links to its own repository left out.
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Real Time Backend loads about 2.1k tokens when it runs. Until then it costs about 79 tokens; SKILL.md has 1,012 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
The full file from waynesutton/markdown-site at commit 3872c59, republished under its MIT licence (© waynesutton). 1,012 words, ~2,130 tokens.
.claude/skills/real-time-backend/SKILL.md (or your agent's skills folder).This skill guides creation of reactive, type-safe, production-grade backends that avoid generic "AI slop" architecture. Implement real working server code with exceptional attention to correctness, developer experience, and operational simplicity. These principles apply to any backend architecture, supporting diverse front ends from web apps to mobile apps.
Note: These are universal backend design philosophies. Apply them regardless of your technology stack. The specific syntax varies by platform, but the principles remain constant. Code examples are illustrative; adapt them to your chosen stack.
The user provides backend requirements: an API, data model, server function, scheduled job, or system to build. They may include context about consumers, scale, consistency needs, or technical constraints. Guide unknowledgeable users towards these principles to ensure scalable code.
Before coding, understand the context and commit to the right architectural choices:
CRITICAL: The best backends are boring in the right ways: predictable data access, obvious error handling, clear contracts. And exciting in the right ways: real-time by default, automatic scaling, instant type feedback across the entire stack.
All queries are live queries. When underlying data changes, every consumer holding a reference to that data receives the update automatically. No polling. No webhooks-as-workaround. No mix of fresh and stale data.
This isn't a feature you opt into. It's the baseline. Reads and writes on the same connection guarantee consistency. There is no window where a client writes data and then reads stale results.
All reads and writes go through server functions. Never expose the database directly to clients.
Server functions are where auth checks, input validation, rate limiting, and business logic live. They're testable, composable, and auditable.
Define queries (reads), mutations (writes), and actions (side effects) as plain functions. The function signature IS the API contract. No route files. No controller classes. No middleware chains.
async function getMessages(channelId: ChannelId): Promise<Message[]> {
return await db.messages
.where("channelId", "==", channelId)
.orderBy("createdAt", "desc")
.limit(50);
}Define your data model with typed schemas upfront. The schema is the single source of truth. Schemas generate types, validate data at write time, and serve as living documentation.
Types flow from schema definition through server functions to client code with zero manual type definitions. Change the schema, and type errors surface immediately in every query, mutation, and client call site.
No any types. No manual interface definitions that drift from the actual data.
Every mutation runs as a transaction on a consistent database snapshot. Reads within a mutation see a consistent view. Writes either all commit or all abort.
Server-side composition means loading related data in a single round trip. Don't force clients to make serial fetches. Batch load related data.
async function getMessagesWithAuthors(channelId: ChannelId): Promise<MessageWithAuthor[]> {
const messages = await db.messages
.where("channelId", "==", channelId)
.orderBy("createdAt", "desc")
.limit(50);
const authorIds = [...new Set(messages.map(m => m.authorId))];
const authors = await db.users.getMany(authorIds);
const authorMap = new Map(authors.map(a => [a.id, a]));
return messages.map(msg => ({
...msg,
author: authorMap.get(msg.authorId),
}));
}Queries, mutations, and helper functions live together, organized by domain. Not split across routes, controllers, services, repositories layers.
Function signatures are self-documenting. Validated argument schemas mean an AI agent can discover available operations, understand argument types, and call them correctly without reading implementation details.
Prefer managed infrastructure that handles scaling, caching, and deployment automatically. Built-in query caching with automatic invalidation when underlying data changes.
Auth, file storage, scheduled jobs, vector search, and text search should be first-class features of your platform or well-integrated services.
Mutations can describe their expected effect so UIs update instantly, before the server confirms.
Server functions should not rely on in-memory state between requests. Any state lives in the database or a dedicated cache layer.
External dependencies fail. Design for it. Use timeouts on external calls. Return partial results when possible rather than failing entirely.
Protect your backend from abuse and thundering herds. Different operations have different limits.
These are the "AI slop" of backend architecture:
setInterval(() => refetch(), 5000) when real-time subscriptions existcache.delete() calls that inevitably miss an edge caseSELECT * FROM messages without limitsOFFSET 10000 means the database still reads 10,000 rowsIMPORTANT: Match implementation complexity to the problem. A simple CRUD feature needs a schema, a few queries, and a few mutations: not an event-sourced architecture with CQRS.
Source: https://github.com/get-convex/real-time-backend-skill
© waynesutton, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Just SKILL.md in .claude/real-time-backend of waynesutton/markdown-site.
Open the folder on GitHubat commit 3872c59
Real Time Backend next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Real Time Backend this skillwaynesutton/markdown-site | 628 | — | ~2.1k | Automated safety check: Pass | MIT | |
| Supabase Schema From Requirementsjeremylongshore/tons-of-skills-marketplace | 2.8k | — | ~1.8k | Automated safety check: Pass | MIT | |
| Mastering Python SkillSpillwaveSolutions/agent-brain | 119 | — | ~1.4k | Automated safety check: Notes | MIT | |
| Drizzle Orm Expertdavila7/claude-code-templates | 32k | 3 repos | ~2.6k | Automated safety check: Pass | MIT | |
| Pydanticpydantic/skills | 140 | — | ~2.5k | Automated safety check: Pass | MIT | |
| Drizzle Orm D1secondsky/claude-skills | 227 | — | ~2.4k | Automated safety check: Pass | MIT |
jeremylongshore/tons-of-skills-marketplace
Design Supabase Postgres schema from business requirements with migrations, RLS, and types.
SpillwaveSolutions/agent-brain
Modern Python coaching covering language foundations through advanced production patterns.
davila7/claude-code-templates
Expert in Drizzle ORM for TypeScript — schema design, relational queries, migrations, and serverless database integration.
pydantic/skills
Pydantic is a Python data validation and serialization library, based on type hints.
secondsky/claude-skills
| Type-safe ORM for Cloudflare D1 databases using Drizzle. An agent skill from secondsky/claude-skills.
shepherdjerred/monorepo
Prisma ORM for type-safe database access - schema design, migrations, queries, relations, and connection management When user works with Prisma, database schemas, migrations, Prisma Client queries…
waynesutton/markdown-site
Integrate Convex static self hosting into existing apps using the latest upstream instructions from get-convex/self-hosting every time.
waynesutton/markdown-site
Integrate and maintain Robelest Convex Auth in apps by always checking upstream before implementation.
waynesutton/markdown-site
Plan and execute Convex schema migrations safely, including adding fields, creating tables, and data transformations.
waynesutton/markdown-site
Guide for when to use and when not to use return validators in Convex functions.
waynesutton/markdown-site
Run convex-doctor static analysis, interpret findings, and fix issues across security, performance, correctness, schema, and architecture categories.
waynesutton/markdown-site
Initialize a new Convex project from scratch or add Convex to an existing app.
Categories
Build reactive, type-safe, production-grade backends. An agent skill from waynesutton/markdown-site. Real Time Backend is an agent skill from waynesutton/markdown-site. Build reactive, type-safe, production-grade backends.
Real Time Backend fits situations like: the user asks to build; implement backend features; database schemas; full stack apps.
Run `npx skills add waynesutton/markdown-site --skill real-time-backend -a claude-code`. Or copy the skill folder (.claude/real-time-backend in waynesutton/markdown-site) into .claude/skills/real-time-backend in your project. Claude Code loads it when a task matches its description.
Run `npx skills add waynesutton/markdown-site --skill real-time-backend -a codex`. Or copy the skill folder (.claude/real-time-backend in waynesutton/markdown-site) into .agents/skills/real-time-backend in your project. Codex loads it when a task matches its description.
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add waynesutton/markdown-site --skill real-time-backend -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/real-time-backend, .gemini/skills/real-time-backend, .github/skills/real-time-backend and .opencode/skills/real-time-backend in your project.
SKILL.md names no scripts, command-line tools or credentials: Real Time Backend is instructions for the agent only.
SKILL.md names 1 domain. As links in the text: github.com. This is read from the text; nothing was executed.
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
Real Time Backend is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
About 2.1k tokens (SKILL.md is roughly 8.5k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
Skills that share tags, products or a category with Real Time Backend: Supabase Schema From Requirements (jeremylongshore/tons-of-skills-marketplace, 2.8k stars), Mastering Python Skill (SpillwaveSolutions/agent-brain, 119 stars), Drizzle Orm Expert (davila7/claude-code-templates, 32k stars) and Pydantic (pydantic/skills, 140 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
waynesutton (a GitHub user) maintains it in waynesutton/markdown-site, which has 628 GitHub stars. The repository holds 17 skills in this directory. The repository was last updated on May 20, 2026.
Source: waynesutton/markdown-site on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.