Search: "database-design"

productivity Intermediate

Notion Database System for Project and Task Management

Act as a Notion power user and productivity systems designer. Create a complete ...

#productivity #Notion #project management

coding intermediate

Python FastAPI: Build Production-Ready REST APIs

Act as a senior Python backend engineer experienced with FastAPI. Help me build ...

#coding #python #fastapi

#Python #pandas #data cleaning

data intermediate

Python Pandas: Data Cleaning and Transformation Workflow

I have a dataset ([CSV/Excel/database] file) with the following issues: [describ...

#coding #Docker #docker-compose

Docker Compose for Full Stack App

Write a docker-compose.yml for a full stack application with: 1) Frontend (React...

#RFM analysis #customer segmentation #data analysis

data Intermediate

Customer Segmentation Analysis with RFM Model

Help me perform customer segmentation using the RFM (Recency, Frequency, Monetar...

#data dictionary #analytics schema #documentation

data Intermediate

ChatGPT Prompt for Data Dictionary from a Messy Analytics Schema

Help me create a clear data dictionary from a messy analytics database so busine...

#coding #sql #window-functions

SQL Window Functions: Advanced Analytics Query Guide

Act as a senior data engineer and SQL expert. Help me master SQL window function...

#cohort analysis #retention #sql

data Advanced

ChatGPT Prompt: Cohort Retention Analysis SQL with Visualization Plan

Write SQL for a cohort retention analysis and explain how to visualize it. Cont...

#python #fastapi #rest-api

Python FastAPI REST API Production-Ready Setup Guide

Build a production-ready Python FastAPI REST API from scratch with enterprise pa...

👁 16 views

data Advanced

ChatGPT Prompt for SQL Query Review Before Sharing a Board Report

Review my SQL query before I use it in an executive or board report where mistak...

#sql review #board reporting #metric qa

👁 15 views

#coding #sql #stored-procedure

SQL Stored Procedure for Data Transformation

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

👁 15 views

coding intermediate

Next.js App Router: Server Components & Data Fetching Patterns

Help me master Next.js 14+ App Router with Server Components. My situation: Pro...

#nextjs #app-router #server-components

👁 15 views

#JWT #authentication #refresh tokens

Authentication System with JWT and Refresh Tokens

Build a complete authentication system with JWT access tokens and refresh tokens...

👁 14 views

#sql optimization #query tuning #performance

ChatGPT Prompt for Refactoring a Slow SQL Query Without Breaking Results

Help me refactor a slow SQL query so it runs faster without changing the busines...

👁 14 views

excel Intermediate

Excel VLOOKUP to XLOOKUP Migration: Formula Modernization Guide

I have existing Excel spreadsheets that use VLOOKUP formulas and I want to moder...

#XLOOKUP #VLOOKUP #Excel formulas

👁 14 views

email Intermediate

Apology Email for Service Outage or Delivery Delay

Write a professional apology email for the following situation: - Situation: [d...

#apology email #service outage #delay notification

SQL Query Optimization for Slow Database Queries

Help me optimize this slow SQL query: [paste your query]. The database is [MySQL...

#coding #sql #database

#postgresql #indexing #performance

PostgreSQL Database Indexing Strategy for Slow Queries

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

data intermediate

SQL Query Builder for Complex Analytics

Help me write an optimized SQL query for my analytics need. Database details: D...

#data #sql #analytics

#kubernetes #k8s #deployment

Kubernetes Deployment Configuration: Production Best Practices Guide

Help me create a production-ready Kubernetes deployment configuration. My applic...

#SQL optimization #query performance #database

data Advanced

SQL Query Optimization Guide for Slow Database Queries

Analyze and optimize the following slow SQL query that is causing performance is...

#coding #database #migration

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