Search: "database"

#sql migration prompt #rollback safe deployment #database schema change

ChatGPT prompt for SQL migration plan with rollback safeguards

Act as a senior database engineer. I need a production-safe SQL migration plan, ...

#debugging #api #rest api

ChatGPT prompt for debugging a REST API that returns 500 errors intermittently

Act as a senior backend engineer specializing in API reliability and debugging. ...

#Power BI #DAX #dashboard

data advanced

Power BI Dashboard Design Executive Sales Report

Help me design a Power BI executive sales dashboard. Data sources: [CRM data / S...

#data #quality #assessment

data intermediate

Data Quality Assessment Framework and Cleaning Checklist

Act as a data quality engineer and analytics architect. Help me build a systemat...

#SQL #GROUP BY #window functions

data intermediate

SQL Advanced Queries: GROUP BY, HAVING, and Window Functions

Help me write advanced SQL queries for [database: PostgreSQL/MySQL/BigQuery/SQL ...

data intermediate

Data Cleaning Strategy and Python Script Generator

Help me clean and prepare a messy dataset for analysis. Dataset details: Data s...

#data #cleaning #python

#data quality #anomaly detection #data monitoring

data Advanced

Automated Data Quality Report with Anomaly Detection

Create a data quality monitoring report for my dataset: - Data source: [e.g., '...

👁 13 views

#coding #sql #query optimization

ChatGPT prompt for reviewing SQL query performance and suggesting optimizations

Act as a senior SQL performance engineer. I will share a slow SQL query, the ta...

👁 13 views

coding Intermediate

Docker Compose: Multi-Service Application Setup and Configuration Guide

Help me set up a Docker Compose configuration for a multi-service application. I...

#Docker #Docker Compose #containers

👁 13 views

data advanced

SQL Query Optimization: Fix Slow Database Performance

Act as a database performance engineer with deep SQL optimization expertise. Hel...

#data #sql #optimization

👁 11 views

coding Intermediate

Node.js Express API: CRUD Operations with Authentication Boilerplate

Help me build a production-ready Node.js REST API with Express. I need a complet...

#Node.js #Express #REST API

👁 11 views

#coding #database #migration

Write a Migration Plan for Renaming a Database Column

Plan a zero-downtime rename of database column [OLD_NAME] to [NEW_NAME] on table...

👁 11 views

legal Intermediate

Write an Internal Data Handling Policy That Employees Will Actually Follow

I need to write an internal data handling policy for a small company. The usual ...

#legal #compliance #data-policy

👁 10 views

excel Intermediate

Decide when to use Power Query vs formulas vs a real database

I keep solving the same data problem three different ways across my team's sprea...

#excel #power query #decision

👁 10 views

#migration #sql #zero-downtime

Write a Defensive Migration Script for a NOT NULL Column Addition

Act as a database migration specialist. I need to add a NOT NULL column [column_...

👁 10 views

#migrations #zero-downtime #schema

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...

👁 9 views

Database Query Optimization with EXPLAIN Analysis

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

#coding #sql #database

#excel #pivot-tables #executive-reporting

excel Intermediate

Excel: Turn a Pivot Table Into Something an Executive Will Actually Read

I built this pivot table: [PASTE STRUCTURE OR SCREENSHOT DESCRIPTION]. It's accu...

#data #database-design #schema

data Advanced

Data: Design a Schema That Won't Need a Migration in 6 Months

I'm designing a schema for [DOMAIN] from scratch. The team wants to ship fast, b...

data Intermediate

Write a SQL Query from a Plain-English Question

You are a SQL expert and data analyst. I will describe a question in plain Engli...

#data #sql #query