菜单
Database optimization, query tuning, indexing strategies, migration management, and performance monitoring for PostgreSQL with Drizzle ORM. Use when optimizing slow queries, designing schemas, creating migrations, or setting up database monitoring.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
| name | database-optimizer |
| version | 2.0 |
| trigger | database optimization, query performance, index tuning, PostgreSQL |
| description | Database optimization, query tuning, indexing strategies, migration management, and performance monitoring for PostgreSQL with Drizzle ORM. Use when optimizing slow queries, designing schemas, creating migrations, or setting up database monitoring. |
// Add index for frequent queries
export const users = pgTable('users', {
id: uuid('id').primaryKey(),
email: varchar('email', { length: 255 }).notNull().unique(),
tier: integer('tier').notNull().default(1),
createdAt: timestamp('created_at').defaultNow(),
}, (table) => ({
emailIdx: index('email_idx').on(table.email),
tierIdx: index('tier_idx').on(table.tier),
createdAtIdx: index('created_at_idx').on(table.createdAt),
}));
export const agentExecutions = pgTable('agent_executions', {
userId: uuid('user_id').references(() => users.id),
agentId: varchar('agent_id', { length: 100 }),
status: varchar('status', { length: 50 }),
createdAt: timestamp('created_at'),
}, (table) => ({
// Composite index for common query pattern
userAgentIdx: index('user_agent_idx').on(table.userId, table.agentId),
// Partial index for active executions
activeIdx: index('active_idx').on(table.createdAt).where(eq(table.status, 'running')),
}));
// Use select instead of include for specific fields
const usersWithPosts = await db
.select({
user: { id: users.id, name: users.name },
postCount: count(posts.id),
lastPost: max(posts.createdAt)
})
.from(users)
.leftJoin(posts, eq(users.id, posts.authorId))
.groupBy(users.id);
async function getPaginatedResults(cursor?: string) {
return db
.select()
.from(posts)
.where(cursor ? lt(posts.createdAt, cursor) : undefined)
.orderBy(desc(posts.createdAt))
.limit(20);
}
// Always make migrations reversible
export async function up(db: DB) {
await db.schema
.alterTable('users')
.addColumn('tier', 'integer', (col) => col.defaultTo(1))
.execute();
// Backfill data
await db.updateTable('users')
.set({ tier: 1 })
.where('tier', 'is', null)
.execute();
}
export async function down(db: DB) {
await db.schema
.alterTable('users')
.dropColumn('tier')
.execute();
}
Algorithm design and analysis skill for DSH; use when working on optimization, data structures, or computational procedures.
Cognitive systems skill for reasoning, memory, and agent behavior; use when designing agent workflows or mental-model tooling.
High-performance numerical and quantum compute skill for scientific workloads; use when working on numeric algorithms, simulation, or acceleration.
Fractal geometry and self-similarity skill; use when working on recursive geometric or visual systems.
Frequency-domain and signal-processing skill; use when working on Fourier, spectral, or resonance analysis.
Financial advisor for GreenEnergyFL — tracks job finances, bills, vendor payments, cash flow, and overdue invoices. Use this skill whenever the user asks about money, payments, invoices, bills, job costs, what's owed, what's coming in, cash flow, overdue accounts, financial summaries, or anything related to GreenEnergyFL's finances. Trigger even if the user just says "check the bills", "what do we owe", "who hasn't paid", "how are we doing financially", or "show me the jobs".