/IndexPostgresDatabase
Add performance indexes to a postgres database — e.g. a postgres database with 40 tables.
Backend & APIsadvanced#postgres#sql
DataLayer
72 commands
/ModelOrdersSchema
Design a normalized schema for an orders and line-items schema — e.g. an orders table joined to line items and products.
Backend & APIsmedium#orders#schema
/BackupOrdersSchema
Design a backup and recovery plan for an orders and line-items schema — e.g. an orders table joined to line items and products.
Backend & APIsmedium#orders#schema
/OptimizeUsersTable
Rewrite slow queries against a users database table — e.g. a users table storing profile and auth data.
Backend & APIseasy#users#table
/MigrateConnectionPool
Write a safe migration for a database connection pool — e.g. a pool exhausting under peak traffic.
Backend & APIsadvanced#connections#pool
/IndexAuditLogTable
Add performance indexes to an audit log table — e.g. a table logging every admin action.
Backend & APIsmedium#audit#logging
/ModelMultiTenantSchema
Design a normalized schema for a multi-tenant database schema — e.g. a shared schema serving 300 tenant orgs.
Backend & APIseasy#multitenant#saas
/BackupMultiTenantSchema
Design a backup and recovery plan for a multi-tenant database schema — e.g. a shared schema serving 300 tenant orgs.
Backend & APIseasy#multitenant#saas
/OptimizeTimeSeriesStore
Rewrite slow queries against a time-series data store — e.g. a metrics store ingesting 10k points per minute.
Backend & APIsadvanced#timeseries#metrics
/SeedSearchIndex
Generate realistic seed data for a search engine index — e.g. an elasticsearch index of product catalog data.
Backend & APIsmedium#search#elasticsearch
/MigrateDataWarehouse
Write a safe migration for a data warehouse schema — e.g. a star-schema warehouse for sales analytics.
Backend & APIseasy#warehouse#analytics
/IndexORMModels
Add performance indexes to orm model definitions — e.g. a set of prisma models for a saas app.
Backend & APIsadvanced#orm#models
/ModelRedisCache
Design a normalized schema for a redis caching layer — e.g. a session cache backed by redis.
Backend & APIsmedium#redis#cache
/BackupRedisCache
Design a backup and recovery plan for a redis caching layer — e.g. a session cache backed by redis.
Backend & APIsmedium#redis#cache
/OptimizeMongoCollection
Rewrite slow queries against a mongodb collection — e.g. a collection of 2 million event documents.
Backend & APIseasy#mongodb#nosql
/SeedPostgresDatabase
Generate realistic seed data for a postgres database — e.g. a postgres database with 40 tables.
Backend & APIsadvanced#postgres#sql
/MigrateOrdersSchema
Write a safe migration for an orders and line-items schema — e.g. an orders table joined to line items and products.
Backend & APIsmedium#orders#schema
/IndexUsersTable
Add performance indexes to a users database table — e.g. a users table storing profile and auth data.
Backend & APIseasy#users#table
/OptimizeConnectionPool
Rewrite slow queries against a database connection pool — e.g. a pool exhausting under peak traffic.
Backend & APIsadvanced#connections#pool
/SeedAuditLogTable
Generate realistic seed data for an audit log table — e.g. a table logging every admin action.
Backend & APIsmedium#audit#logging
/MigrateMultiTenantSchema
Write a safe migration for a multi-tenant database schema — e.g. a shared schema serving 300 tenant orgs.
Backend & APIseasy#multitenant#saas
/IndexTimeSeriesStore
Add performance indexes to a time-series data store — e.g. a metrics store ingesting 10k points per minute.
Backend & APIsadvanced#timeseries#metrics
/ModelSearchIndex
Design a normalized schema for a search engine index — e.g. an elasticsearch index of product catalog data.
Backend & APIsmedium#search#elasticsearch
/BackupSearchIndex
Design a backup and recovery plan for a search engine index — e.g. an elasticsearch index of product catalog data.
Backend & APIsmedium#search#elasticsearch
/OptimizeDataWarehouse
Rewrite slow queries against a data warehouse schema — e.g. a star-schema warehouse for sales analytics.
Backend & APIseasy#warehouse#analytics
/SeedORMModels
Generate realistic seed data for orm model definitions — e.g. a set of prisma models for a saas app.
Backend & APIsadvanced#orm#models
/MigrateRedisCache
Write a safe migration for a redis caching layer — e.g. a session cache backed by redis.
Backend & APIsmedium#redis#cache
/IndexMongoCollection
Add performance indexes to a mongodb collection — e.g. a collection of 2 million event documents.
Backend & APIseasy#mongodb#nosql
/ModelPostgresDatabase
Design a normalized schema for a postgres database — e.g. a postgres database with 40 tables.
Backend & APIsadvanced#postgres#sql
/BackupPostgresDatabase
Design a backup and recovery plan for a postgres database — e.g. a postgres database with 40 tables.
Backend & APIsadvanced#postgres#sql
/OptimizeOrdersSchema
Rewrite slow queries against an orders and line-items schema — e.g. an orders table joined to line items and products.
Backend & APIsmedium#orders#schema
/SeedUsersTable
Generate realistic seed data for a users database table — e.g. a users table storing profile and auth data.
Backend & APIseasy#users#table
/IndexConnectionPool
Add performance indexes to a database connection pool — e.g. a pool exhausting under peak traffic.
Backend & APIsadvanced#connections#pool
/ModelAuditLogTable
Design a normalized schema for an audit log table — e.g. a table logging every admin action.
Backend & APIsmedium#audit#logging
/BackupAuditLogTable
Design a backup and recovery plan for an audit log table — e.g. a table logging every admin action.
Backend & APIsmedium#audit#logging
/OptimizeMultiTenantSchema
Rewrite slow queries against a multi-tenant database schema — e.g. a shared schema serving 300 tenant orgs.
Backend & APIseasy#multitenant#saas
/SeedTimeSeriesStore
Generate realistic seed data for a time-series data store — e.g. a metrics store ingesting 10k points per minute.
Backend & APIsadvanced#timeseries#metrics
/MigrateSearchIndex
Write a safe migration for a search engine index — e.g. an elasticsearch index of product catalog data.
Backend & APIsmedium#search#elasticsearch
/IndexDataWarehouse
Add performance indexes to a data warehouse schema — e.g. a star-schema warehouse for sales analytics.
Backend & APIseasy#warehouse#analytics
/ModelORMModels
Design a normalized schema for orm model definitions — e.g. a set of prisma models for a saas app.
Backend & APIsadvanced#orm#models
/BackupORMModels
Design a backup and recovery plan for orm model definitions — e.g. a set of prisma models for a saas app.
Backend & APIsadvanced#orm#models
/OptimizeRedisCache
Rewrite slow queries against a redis caching layer — e.g. a session cache backed by redis.
Backend & APIsmedium#redis#cache
/SeedMongoCollection
Generate realistic seed data for a mongodb collection — e.g. a collection of 2 million event documents.
Backend & APIseasy#mongodb#nosql
/MigratePostgresDatabase
Write a safe migration for a postgres database — e.g. a postgres database with 40 tables.
Backend & APIsadvanced#postgres#sql
/IndexOrdersSchema
Add performance indexes to an orders and line-items schema — e.g. an orders table joined to line items and products.
Backend & APIsmedium#orders#schema
/ModelUsersTable
Design a normalized schema for a users database table — e.g. a users table storing profile and auth data.
Backend & APIseasy#users#table
/BackupUsersTable
Design a backup and recovery plan for a users database table — e.g. a users table storing profile and auth data.
Backend & APIseasy#users#table
/SeedConnectionPool
Generate realistic seed data for a database connection pool — e.g. a pool exhausting under peak traffic.
Backend & APIsadvanced#connections#pool
/MigrateAuditLogTable
Write a safe migration for an audit log table — e.g. a table logging every admin action.
Backend & APIsmedium#audit#logging
/IndexMultiTenantSchema
Add performance indexes to a multi-tenant database schema — e.g. a shared schema serving 300 tenant orgs.
Backend & APIseasy#multitenant#saas
/ModelTimeSeriesStore
Design a normalized schema for a time-series data store — e.g. a metrics store ingesting 10k points per minute.
Backend & APIsadvanced#timeseries#metrics
/BackupTimeSeriesStore
Design a backup and recovery plan for a time-series data store — e.g. a metrics store ingesting 10k points per minute.
Backend & APIsadvanced#timeseries#metrics
/OptimizeSearchIndex
Rewrite slow queries against a search engine index — e.g. an elasticsearch index of product catalog data.
Backend & APIsmedium#search#elasticsearch
/SeedDataWarehouse
Generate realistic seed data for a data warehouse schema — e.g. a star-schema warehouse for sales analytics.
Backend & APIseasy#warehouse#analytics
/MigrateORMModels
Write a safe migration for orm model definitions — e.g. a set of prisma models for a saas app.
Backend & APIsadvanced#orm#models
/IndexRedisCache
Add performance indexes to a redis caching layer — e.g. a session cache backed by redis.
Backend & APIsmedium#redis#cache
/ModelMongoCollection
Design a normalized schema for a mongodb collection — e.g. a collection of 2 million event documents.
Backend & APIseasy#mongodb#nosql
/BackupMongoCollection
Design a backup and recovery plan for a mongodb collection — e.g. a collection of 2 million event documents.
Backend & APIseasy#mongodb#nosql
/OptimizePostgresDatabase
Rewrite slow queries against a postgres database — e.g. a postgres database with 40 tables.
Backend & APIsadvanced#postgres#sql
/SeedOrdersSchema
Generate realistic seed data for an orders and line-items schema — e.g. an orders table joined to line items and products.
Backend & APIsmedium#orders#schema
/MigrateUsersTable
Write a safe migration for a users database table — e.g. a users table storing profile and auth data.
Backend & APIseasy#users#table
/ModelConnectionPool
Design a normalized schema for a database connection pool — e.g. a pool exhausting under peak traffic.
Backend & APIsadvanced#connections#pool
/BackupConnectionPool
Design a backup and recovery plan for a database connection pool — e.g. a pool exhausting under peak traffic.
Backend & APIsadvanced#connections#pool
/OptimizeAuditLogTable
Rewrite slow queries against an audit log table — e.g. a table logging every admin action.
Backend & APIsmedium#audit#logging
/SeedMultiTenantSchema
Generate realistic seed data for a multi-tenant database schema — e.g. a shared schema serving 300 tenant orgs.
Backend & APIseasy#multitenant#saas
/MigrateTimeSeriesStore
Write a safe migration for a time-series data store — e.g. a metrics store ingesting 10k points per minute.
Backend & APIsadvanced#timeseries#metrics
/IndexSearchIndex
Add performance indexes to a search engine index — e.g. an elasticsearch index of product catalog data.
Backend & APIsmedium#search#elasticsearch
/ModelDataWarehouse
Design a normalized schema for a data warehouse schema — e.g. a star-schema warehouse for sales analytics.
Backend & APIseasy#warehouse#analytics
/BackupDataWarehouse
Design a backup and recovery plan for a data warehouse schema — e.g. a star-schema warehouse for sales analytics.
Backend & APIseasy#warehouse#analytics
/OptimizeORMModels
Rewrite slow queries against orm model definitions — e.g. a set of prisma models for a saas app.
Backend & APIsadvanced#orm#models
/SeedRedisCache
Generate realistic seed data for a redis caching layer — e.g. a session cache backed by redis.
Backend & APIsmedium#redis#cache
/MigrateMongoCollection
Write a safe migration for a mongodb collection — e.g. a collection of 2 million event documents.
Backend & APIseasy#mongodb#nosql