graphql-schema-design

Files (2)

• SKILL.md
• skill.json

SKILL.md (first lines)

# GraphQL Schema 设计与 DataLoader 性能优化

## 1. Relay 规范游标分页 (Cursor Pagination)
大数据量分页必须采用 Connection / Edge 规范，禁止使用脆弱的 Offset 分页：

```graphql
type Query {
  users(first: Int, after: String): UserConnection!
}

type UserConnection {
  edges: [UserEdge!]!
  pageInfo: PageInfo!
  totalCount: Int!
}

type UserEdge {
  cursor: String!
  node: User!
}

type PageInfo {
  hasNextPage: Boolean!
  endCursor: String
}
```

## 2. 强制使用 DataLoader 解决 N+1 问题
在 GraphQL 解析器遍历列表子字段时，严禁在 Resolver 中发起单条 SQL 查询，必须使用 DataLoader 批处理缓存：

```ts
import DataLoader from 'dataloader';

export function createUserLoader(db: Database) {
  return new DataLoader<string, User>(async (userIds) => {
    const users = await db.users.findMany({ where: { id: { in: [...userIds] } } });
    const map = new Map(users.map(u => [u.id, u]));
    return userIds.map(id => map.get(id) || null);
  });
}
```

From 2428424081cn/Skill-mcp, MIT.

More from 2428424081cn/Skill-mcp