supabase
Handles the full Supabase workflow from schema changes to deployment, with built-in security guardrails that catch common traps like RLS...
api-designer
Design RESTful or GraphQL APIs with proper conventions. Creates endpoint specifications, request/response schemas, and documentation. Use when user says 'design API', 'endpoints', 'REST', 'GraphQL', or 'API spec'.
Full skill instructions
You are an expert at designing clean REST and GraphQL APIs.
| Action | Method | Endpoint | Response |
|---|---|---|---|
| List | GET | /resources | 200 + [] |
| Get one | GET | /resources/:id | 200 or 404 |
| Create | POST | /resources | 201 + object |
| Update | PUT/PATCH | /resources/:id | 200 + object |
| Delete | DELETE | /resources/:id | 204 or 404 |
What entities does this feature involve?
CRUD? Custom actions?
Standard error format, appropriate status codes.
OpenAPI spec or markdown.
GET /users
GET /users/123
POST /users
PUT /users/123
DELETE /users/123
GET /users/123/posts
POST /users/123/posts
GET /getUser/123 # verb in URL
GET /user/123 # singular
POST /users/create # redundant
GET /users?action=delete # wrong method
{
"error": {
"code": "VALIDATION_ERROR",
"message": "Invalid input",
"details": [
{"field": "email", "message": "Invalid email format"}
]
}
}
| Code | When |
|---|---|
| 200 | Success |
| 201 | Created |
| 204 | No Content (deleted) |
| 400 | Bad Request (validation) |
| 401 | Unauthorized (not logged in) |
| 403 | Forbidden (no permission) |
| 404 | Not Found |
| 409 | Conflict |
| 500 | Server Error |
{
"data": [...],
"pagination": {
"page": 1,
"per_page": 20,
"total": 100,
"total_pages": 5
}
}
Or cursor-based:
{
"data": [...],
"next_cursor": "abc123",
"has_more": true
}
openapi: 3.0.0
info:
title: API Name
version: 1.0.0
paths:
/resources:
get:
summary: List resources
responses:
'200':
description: Success
content:
application/json:
schema:
type: array
items:
$ref: '#/components/schemas/Resource'
components:
schemas:
Resource:
type: object
properties:
id:
type: string
name:
type: string
| Use GraphQL | Use REST |
|---|---|
| Complex data relationships | Simple CRUD |
| Mobile apps (reduce over-fetching) | Caching critical |
| Multiple clients need different data | Simpler tooling |
| Nested data in single request | File uploads |
type User {
id: ID!
email: String!
name: String
posts: [Post!]!
createdAt: DateTime!
}
type Post {
id: ID!
title: String!
content: String!
author: User!
published: Boolean!
}
type Query {
user(id: ID!): User
users(first: Int, after: String): UserConnection!
post(id: ID!): Post
}
type Mutation {
createUser(input: CreateUserInput!): User!
updateUser(id: ID!, input: UpdateUserInput!): User!
deleteUser(id: ID!): Boolean!
}
input CreateUserInput {
email: String!
name: String
}
input UpdateUserInput {
email: String
name: String
}
| Element | Convention | Example |
|---|---|---|
| Types | PascalCase | User, BlogPost |
| Fields | camelCase | createdAt, firstName |
| Queries | camelCase, noun | user, users, post |
| Mutations | camelCase, verb+noun | createUser, updatePost |
| Inputs | PascalCase + Input | CreateUserInput |
type UserConnection {
edges: [UserEdge!]!
pageInfo: PageInfo!
totalCount: Int!
}
type UserEdge {
node: User!
cursor: String!
}
type PageInfo {
hasNextPage: Boolean!
hasPreviousPage: Boolean!
startCursor: String
endCursor: String
}
# Query
query {
users(first: 10, after: "cursor123") {
edges {
node { id name }
cursor
}
pageInfo { hasNextPage endCursor }
}
}
type MutationResult {
success: Boolean!
message: String
errors: [FieldError!]
}
type FieldError {
field: String!
message: String!
}
# Or use union types
union CreateUserResult = User | ValidationError | AuthError
from ariadne import QueryType, MutationType
query = QueryType()
mutation = MutationType()
@query.field("user")
def resolve_user(_, info, id):
return db.get_user(id)
@query.field("users")
def resolve_users(_, info, first=10, after=None):
return db.paginate_users(first, after)
@mutation.field("createUser")
def resolve_create_user(_, info, input):
return db.create_user(**input)
from ariadne import load_schema_from_path
from graphql import GraphQLResolveInfo
# BAD: N+1 queries
@query.field("users")
def resolve_users(_, info):
users = db.get_users()
for user in users:
user.posts = db.get_posts_for_user(user.id) # N queries!
return users
# GOOD: DataLoader
from aiodataloader import DataLoader
async def batch_load_posts(user_ids):
posts = await db.get_posts_for_users(user_ids)
return [posts.get(uid, []) for uid in user_ids]
posts_loader = DataLoader(batch_load_posts)
@query.field("user")
async def resolve_user_posts(user, info):
return await posts_loader.load(user.id)
| Factor | REST | GraphQL |
|---|---|---|
| Learning curve | Lower | Higher |
| Caching | Built-in HTTP | Manual |
| Over-fetching | Common | Solved |
| Under-fetching | Common | Solved |
| File uploads | Native | Needs workaround |
| Real-time | WebSocket separate | Subscriptions built-in |
Default to REST unless you have specific GraphQL needs.
/getUser, /createOrder)API, REST, endpoints, design API, OpenAPI, Swagger, routes, GraphQL, schema, query, mutation
Handles the full Supabase workflow from schema changes to deployment, with built-in security guardrails that catch common traps like RLS...
Comprehensive guides and best practices for Neon Serverless Postgres, covering setup, connection methods, authentication, and platform APIs.
Guide for setting up and using Firebase Authentication. Use this skill when the user's app requires user sign-in, user management, or secure data access using auth rules.
A skill to evaluate how secure Firestore security rules are. Use this when Firestore security rules are updated to ensure that the generated rules are extremely secure and robust.
Official skill for integrating Firebase AI Logic (Gemini API) into web applications. Covers setup, multimodal inference, structured output, and security.
Complete Better Auth server and client setup with database adapters, session management, plugins, and security configuration.
Deploy and manage projects on Vercel using token-based authentication. Use when working with Vercel CLI using access tokens rather than interactive login — e.g. "deploy to vercel", "set up vercel", "add environment variables to vercel".
Complete Cloudflare platform integration with decision trees for compute, storage, AI, networking, security, and infrastructure-as-code.
Run Azure compliance and security audits with azqr plus Key Vault expiration checks. Covers best-practice assessment, resource review, policy/compliance validation, and security posture checks. WHEN: compliance scan, security audit, BEFORE running azqr (compliance cli tool), Azure best practices, Key Vault expiration check, expired certificates, expiring secrets, orphaned resources, compliance assessment.
Send, read, and manage Gmail messages, drafts, labels, and account settings.
Comprehensive website auditing across 230+ rules in 21 categories including SEO, performance, security, and accessibility.
Shared authentication, CLI syntax, and output formatting patterns for gws Google Workspace commands.
Discover your celebrity doppelgänger with StarByFace!
GeoSpy: Pricing, Features, FAQs, and Alternatives for AI Teams
Detect AI-generated voices to protect against audio fraud.
Ensure Your Content's Originality with AI Plagiarism Checker
Upscale images by 400% without quality loss
Protect your social media from copyright disputes
Accurately Detect AI-Generated Content with TheChecker.AI
Chrome extension that detects and flags AI-generated content