💻 Database Coding & Development Prompts

Python, JavaScript, SQL, debugging, API

9 prompts available

All Coding & Development 254 Debugging 31 refactoring 31 code review 26 Testing 17 Architecture 11 Database 9 DevOps 8 Python 7 SQL 6 frontend development 5 DevOps & Infrastructure 4 API Development 4 Testing & QA 4 Backend 3 Code Comprehension 3 Code Review & Quality 3 Learning 3 TypeScript 3 Databases 3 Database Design 2 JavaScript & TypeScript 2 Tools & Workflow 2 React 2 SQL Performance 2 web scraping 2 Documentation 2 JavaScript 2 Backend Development 2 Git & Version Control 2 Version Control 2 DevOps & CI/CD 1 Python & Backend Development 1 Database Engineering 1 Onboarding 1 Release 1 Planning 1 Tech Debt 1 Estimation 1 Postmortems 1 technical documentation 1 best-practices 1 Project Management 1 test automation 1 DevOps & Automation 1 api troubleshooting 1 database changes 1 api testing 1 Frontend & UI 1 Backend Architecture 1 bug triage 1 Review 1 api-design 1 sql optimization 1 Backend & APIs 1 SQL & Database 1 validation 1 Frontend 1 Observability 1 Git & Workflow 1 Git 1 Regex 1 Cloud & Serverless 1 DevOps & Deployment 1 Frontend Architecture 1 Workflow 1 Algorithms 1 Performance 1 Rust 1 Reliability 1 Code Quality & Best Practices 1 Python & Scripting 1 Incident & Operations 1

Showing 9 prompts in Database

Database Advanced

Database Schema Design from Requirements

Act as a senior database architect. Design a normalized database schema based on...

#database design #schema #SQL

👁 18 views Open →

Database Advanced

SQL Query Optimizer

Analyze this SQL query for performance issues: [QUERY]. Provide: execution plan ...

#SQL #optimization #performance

👁 16 views Open →

database advanced

SQL Stored Procedure for Data Transformation

Write a SQL stored procedure in [MySQL / PostgreSQL / SQL Server] for the follow...

#coding #sql #stored-procedure

👁 16 views Open →

Database Advanced

Write a Postgres Migration That Adds a NOT NULL Column to a Large Table

Write a safe Postgres migration for a 50M-row production table (heavy write traf...

#coding #postgres #migration

👁 15 views Open →

Database advanced

PostgreSQL Database Indexing Strategy for Slow Queries

Analyze and fix slow query performance in PostgreSQL for [describe your schema a...

#postgresql #indexing #performance

👁 14 views Open →

Database Intermediate

Write a Migration Script That Can Be Re-run Safely

Act as a database engineer. I need a migration script that can be re-run safely ...

#coding #database #migration

👁 13 views Open →

Database Intermediate

Generate a SQL Migration With Safe Rollback

Act as a database engineer. Write a {{database: e.g., PostgreSQL 15}} migration ...

#coding #sql #migration

👁 12 views Open →

Database Advanced

Database Query Optimization with EXPLAIN Analysis

Analyze the following slow SQL query and its EXPLAIN output. Identify the bottle...

#coding #sql #database

👁 5 views Open →

Database Advanced

Coding: Write a Migration Plan for a Schema Change That Can't Take Downtime

I need to change a schema (rename column, change type, add NOT NULL) on a high-t...

#migrations #zero-downtime #schema

👁 4 views Open →