Loading...
Loading...
Search for a command to run...
Browse 13,586+ expert-crafted prompts
Showing 20 prompts
Implement query routing between primary and read replicas
Implement read replica query routing for this setup:
**Database System:** {{DATABASE_SYSTEM}}
**Application Stack:** {{APPLICATION_STACK}}
**Replica Configuration:** {{REPLICA_CON...{{DATABASE_SYSTEM}{{APPLICATION_STACK}{{REPLICA_CONFIG}{{RW_PATTERNS}+1 moreManage sequences and auto-increment columns effectively
Help manage sequences/auto-increment for this scenario:
**Current Schema:**
```sql
{{SCHEMA}}
```
**Issue/Requirement:** {{ISSUE}}
**Expected Behavior:** {{EXPECTED_BEHAVIOR}}
**...{{SCHEMA}{{ISSUE}{{EXPECTED_BEHAVIOR}{{DATABASE_SYSTEM}Implement soft delete pattern with data recovery
Implement soft delete for these tables:
**Tables:**
```sql
{{TABLE_SCHEMA}}
```
**Requirements:**
- Retention period: {{RETENTION}}
- Recovery needs: {{RECOVERY_NEEDS}}
- Audit r...{{TABLE_SCHEMA}{{RETENTION}{{RECOVERY_NEEDS}{{AUDIT}+2 moreImplement row-level security policies in your database
Implement row-level security for this database:
**Schema:**
```sql
{{SCHEMA}}
```
**Security Requirements:**
{{SECURITY_REQUIREMENTS}}
**User Roles:** {{USER_ROLES}}
**Access Pa...{{SCHEMA}{{SECURITY_REQUIREMENTS}{{USER_ROLES}{{ACCESS_PATTERNS}+1 moreWork with JSON data types in relational databases
Implement JSON column handling for this requirement:
**Table with JSON Column:**
```sql
{{TABLE_SCHEMA}}
```
**JSON Structure:**
```json
{{JSON_STRUCTURE}}
```
**Operations Need...{{TABLE_SCHEMA}{{JSON_STRUCTURE}{{OPERATIONS}{{DATABASE_SYSTEM}Implement robust query timeout handling strategies
Implement query timeout handling for this scenario:
**Application Stack:** {{APPLICATION_STACK}}
**Database System:** {{DATABASE_SYSTEM}}
**Query Types:** {{QUERY_TYPES}}
**Curren...{{APPLICATION_STACK}{{DATABASE_SYSTEM}{{QUERY_TYPES}{{TIMEOUT_ISSUES}+1 moreCreate comprehensive database health monitoring scripts
Create a health check script for this database:
**Database System:** {{DATABASE_SYSTEM}}
**Key Metrics to Monitor:**
{{METRICS}}
**Alert Thresholds:** {{THRESHOLDS}}
**Monitoring...{{DATABASE_SYSTEM}{{METRICS}{{THRESHOLDS}{{FREQUENCY}+1 moreDesign a type-safe query builder API
Design a query builder API for this use case:
**Target Database:** {{DATABASE}}
**Programming Language:** {{LANGUAGE}}
**Query Types Needed:** {{QUERY_TYPES}}
**Type Safety Requir...{{DATABASE}{{LANGUAGE}{{QUERY_TYPES}{{TYPE_SAFETY}+1 moreCompare database schemas and generate sync scripts
Compare these two database schemas:
**Source Schema:**
```sql
{{SOURCE_SCHEMA}}
```
**Target Schema:**
```sql
{{TARGET_SCHEMA}}
```
**Database System:** {{DATABASE_SYSTEM}}
**Sy...{{SOURCE_SCHEMA}{{TARGET_SCHEMA}{{DATABASE_SYSTEM}{{SYNC_DIRECTION}Build secure and optimized database connection strings
Build a database connection string for this setup:
**Database System:** {{DATABASE_SYSTEM}}
**Host/Server:** {{HOST}}
**Database Name:** {{DATABASE_NAME}}
**Authentication Method:...{{DATABASE_SYSTEM}{{HOST}{{DATABASE_NAME}{{AUTH_METHOD}+3 moreImplement comprehensive audit logging for database changes
Implement an audit trail system for this database:
**Tables to Audit:** {{TABLES}}
**Audit Requirements:**
- Changes to track: {{CHANGES_TO_TRACK}}
- User identification: {{USER_I...{{TABLES}{{CHANGES_TO_TRACK}{{USER_IDENTIFICATION}{{RETENTION}+2 moreDesign multi-tenant database architecture
Design a multi-tenant database architecture:
**Application Type:** {{APPLICATION_TYPE}}
**Number of Tenants:** {{TENANT_COUNT}}
**Data Isolation Requirements:** {{ISOLATION_REQUIR...{{APPLICATION_TYPE}{{TENANT_COUNT}{{ISOLATION_REQUIREMENTS}{{SIZE_VARIATION}+2 moreImplement efficient pagination for large datasets
Implement efficient pagination for this query:
**Base Query:**
```sql
{{BASE_QUERY}}
```
**Table Size:** {{TABLE_SIZE}}
**Sort Requirements:** {{SORT_REQUIREMENTS}}
**Current Pag...{{BASE_QUERY}{{TABLE_SIZE}{{SORT_REQUIREMENTS}{{CURRENT_METHOD}+2 moreDesign caching strategies to reduce database load
Design a caching strategy for this database workload:
**Database System:** {{DATABASE_SYSTEM}}
**Application Stack:** {{APPLICATION_STACK}}
**Hot Data Patterns:** {{HOT_DATA}}
**Q...{{DATABASE_SYSTEM}{{APPLICATION_STACK}{{HOT_DATA}{{QUERY_PATTERNS}+2 moreRefactor complex SQL queries for readability and performance
Refactor this complex SQL query:
**Original Query:**
```sql
{{ORIGINAL_QUERY}}
```
**Query Purpose:** {{QUERY_PURPOSE}}
**Performance Issues:** {{PERFORMANCE_ISSUES}}
**Readabili...{{ORIGINAL_QUERY}{{QUERY_PURPOSE}{{PERFORMANCE_ISSUES}{{READABILITY_CONCERNS}+1 moreImplement Change Data Capture for real-time data sync
Set up Change Data Capture for this database:
**Database System:** {{DATABASE_SYSTEM}}
**Tables to Track:** {{TABLES}}
**Target Systems:** {{TARGET_SYSTEMS}}
**Latency Requirement...{{DATABASE_SYSTEM}{{TABLES}{{TARGET_SYSTEMS}{{LATENCY}+2 moreStrategic denormalization for performance optimization
Advise on denormalization for this normalized schema:
**Current Schema:**
```sql
{{CURRENT_SCHEMA}}
```
**Performance Issues:**
{{PERFORMANCE_ISSUES}}
**Query Patterns:**
{{QUER...{{CURRENT_SCHEMA}{{PERFORMANCE_ISSUES}{{QUERY_PATTERNS}{{READ_WRITE_RATIO}+1 moreImplement full-text search in your database
Implement full-text search for this requirement:
**Table Schema:**
```sql
{{TABLE_SCHEMA}}
```
**Searchable Fields:** {{SEARCHABLE_FIELDS}}
**Search Requirements:**
- {{SEARCH_RE...{{TABLE_SCHEMA}{{SEARCHABLE_FIELDS}{{SEARCH_REQUIREMENTS}{{DATABASE_SYSTEM}+1 moreDesign table partitioning for large datasets
Design a partitioning strategy for this table:
**Table Schema:**
```sql
{{TABLE_SCHEMA}}
```
**Data Characteristics:**
- Volume: {{DATA_VOLUME}}
- Growth Rate: {{GROWTH_RATE}}
- ...{{TABLE_SCHEMA}{{DATA_VOLUME}{{GROWTH_RATE}{{DATE_RANGE}+3 moreDesign ETL pipelines for data integration
Design an ETL pipeline for this data integration:
**Source Systems:**
{{SOURCE_SYSTEMS}}
**Target Database:**
{{TARGET_DATABASE}}
**Data Transformations:**
{{TRANSFORMATIONS}}
...{{SOURCE_SYSTEMS}{{TARGET_DATABASE}{{TRANSFORMATIONS}{{SCHEDULE}+2 moreScroll for more