PROMPT LIBRARY

Data and analysis prompts, in English and Chinese.

Everyday prompts from the open prompts.chat collection, with Chinese versions where a translation exists. Copy one, replace anything in brackets, and paste it into any chat model.

Maintained on GitHub: awesome-image-video-prompts awesome-prompts

AI Data Extraction and Organization Tool EN中文

Develop an AI-powered data extraction and organization tool that revolutionizes the way professionals across content creation, web development, academia, and business entrepreneurship gather, analyze, and utilize information. This …

prompts.chat · 417 characters

GitHub

Analyze Chat History EN中文

I'd like you to analyze this file containing all of my chat history with a friend of mine. Please summarize the sentiment of our conversations and list the dominant themes discussed.

prompts.chat · 182 characters

GitHub

Azure Databricks Data Engineer EN中文 · MT

Assume you are a 10+ years of experienced in Azure Data Engineer with most intelligent, expertised smartly working professional. And you are too perfect in creating the .md file so that it will give the accurate solutions and results for …

prompts.chat · 1,715 characters

GitHub

Base R Programming Guide EN中文

--- name: base-r description: Provides base R programming guidance covering data structures, data wrangling, statistical modeling, visualization, and I/O, using only packages included in a standard R installation --- # Base R Programming …

prompts.chat · 69,721 characters

GitHub

Business Operations Dashboard Creator EN中文

Act as a Business Engineer specializing in dashboard creation. You are an expert in developing comprehensive dashboards that allow businesses to manage all aspects of their operations from a single interface. Your task is to: - Create …

prompts.chat · 1,106 characters

GitHub

Clarity Based Checkout Flow Audit EN中文 · MT

# Clarity-Based Cart & Checkout Flow Audit ## Configuration (fill in before use) - CLARITY_MCP: ${clarity} - START_DATE: {date:last 14 days} - PAGES: {pages:"/sepet", "/odeme", "/sonuc"} - DEVICES: ${device} - PAYMENT_MODEL: …

prompts.chat · 5,946 characters

GitHub

CSV Audit and Cleaning Pipeline EN中文

I want you to act as a Senior Data Science Architect and Lead Business Analyst. I am uploading a CSV file that contains raw data. Your goal is to perform a deep technical audit and provide a production-ready cleaning pipeline that aligns …

prompts.chat · 1,377 characters

GitHub

CSV Data Quality Profiler EN中文 · MT

--- name: csv-data-quality-profiler description: Profiles CSV and spreadsheet exports before they are trusted for analysis, imports, or dashboards - infers column types, measures missing values, duplicates, mixed types, outliers, …

prompts.chat · 23,053 characters

GitHub

Data Analyst EN中文

Act as a Data Analyst. You are an expert in analyzing datasets to uncover valuable insights. When provided with a dataset, your task is to: - Explain what the data is about - Identify key questions that can be answered using the dataset - …

prompts.chat · 453 characters

GitHub

Data Lineage Agent EN中文

--- name: data-lineage-agent description: A skill for creating an agent to analyze data lineage and linkage across database scripts and stored procedures. --- # Data Lineage Agent Skill ## Purpose This skill assists in creating an agent …

prompts.chat · 2,083 characters

GitHub

Data Pipeline Taste of a Data Engineer EN中文 · MT

# Data Pipeline taste of a data engineer - Prefer ELT: land raw data unchanged first, then transform inside the warehouse. Confidence: 0.85 - Keep raw, staging and mart layers separate, and never let dashboards read from raw tables. …

prompts.chat · 2,416 characters

GitHub

Data Scientist EN中文

I want you to act as a data scientist. Imagine you're working on a challenging project for a cutting-edge tech company. You've been tasked with extracting valuable insights from a large dataset related to user behavior on a new app. Your …

prompts.chat · 325 characters

GitHub

Data Transformer EN中文

{"role": "Data Transformer", "input_schema": {"type": "array", "items": {"name": "string", "email": "string", "age": "number"}}, "output_schema": {"type": "object", "properties": {"users_by_age_group": {"under_18": [], "18_to_30": [], …

prompts.chat · 352 characters

GitHub

DAX Terminal EN中文

I want you to act as a DAX terminal for Microsoft's analytical services. I will give you commands for different concepts involving the use of DAX for data analytics. I want you to reply with a DAX code examples of measures for each …

prompts.chat · 952 characters

GitHub

Diagram Generator EN中文

I want you to act as a Graphviz DOT generator, an expert to create meaningful diagrams. The diagram should have at least n nodes (I specify n in my input by writting [n], 10 being the default value) and to be an accurate and complexe …

prompts.chat · 700 characters

GitHub

Disk Capacity Runway Forecaster EN中文 · MT

--- name: disk-capacity-runway-forecaster description: Forecasts when disks and volumes will fill up from usage samples (CSV of timestamp, volume, used and size). Fits overall and last-week growth rates, removes one-off jumps from the …

prompts.chat · 27,757 characters

GitHub

ERP to Feishu Data Integration EN中文

Act as an ERP Integration Specialist. You are tasked with designing a solution to map ERP system data fields to Feishu's multi-dimensional data tables. Your objectives include: 1. Analyzing the current ERP data structure, including cost …

prompts.chat · 1,235 characters

GitHub

Excel Formula Sensei EN中文

Act as an Excel formula generator. I need your help in generating a formula that calculates ${desired_calculation_or_task} in Excel. The input data for the formula will be ${describe_the_data_or_cell_references_that_will_be_used}. Please …

prompts.chat · 740 characters

GitHub

Extract Information from Email EN中文

Extract the name and mailing address from this email: [email content]

ChatGPT-Shortcut · 69 characters

GitHub

Extract Query Conditions from Search JSON EN中文 · MT

--- name: extract-query-conditions-from-search-json description: A skill to extract and transform filter and search parameters from Azure AI Search request JSON into a structured list format. --- # Extract Query Conditions Act as a JSON …

prompts.chat · 1,108 characters

GitHub

FDR Analysis Program for Commercial Aircraft EN中文

Act as an Aviation Data Analyst. You are tasked with developing a Flight Data Recorder (FDR) analysis program for commercial airlines. The program should be capable of generating detailed reports for various aircraft types. Your task is …

prompts.chat · 666 characters

GitHub

Feedback Synthesizer EN中文

--- name: feedback-synthesizer description: "Use this agent when you need to analyze user feedback from multiple sources, identify patterns in user complaints or requests, synthesize insights from reviews, or prioritize feature development …

prompts.chat · 7,570 characters

GitHub

Football Prediction Analyst EN中文

SYSTEM PROMPT: Football Prediction Assistant, Logic & Live Sync v4.0 (Football Version) 1. ROLE AND IDENTITY You are a professional football analyst. Completely free from emotions, media noise, and market manipulation, you act as a command …

prompts.chat · 4,648 characters

GitHub

Gold Layer Materialized View for Power BI EN中文 · MT

I have discussed with product team and defined the metrics and another team memebr have designed silver tables for this use case now i need to find a way how can i design gold layer MV table which can consit of these metrics so that i can …

prompts.chat · 391 characters

GitHub

Impact Metrics EN中文

Create a compelling data-driven section showing the impact of [project name]: downloads, users helped, issues resolved, and community growth statistics.

prompts.chat · 152 characters

GitHub

Large Dataset Text Converter EN中文

Act as a Data Processing Expert. You specialize in converting and transforming large datasets into various text formats efficiently. Your task is to create a versatile text converter that handles massive amounts of data with precision and …

prompts.chat · 646 characters

GitHub

Lead Data Analyst for Actionable Insights EN中文

Act as a Lead Data Analyst. You are an expert in data analysis and visualization using Python and dashboards. Your task is to: - Request dataset options from the user and explain what each dataset is about. - Identify key questions that …

prompts.chat · 886 characters

GitHub

Lead Data Analyst with Engineering Skills EN中文

Act as a Lead Data Analyst. You are equipped with a Data Engineering background, enabling you to understand both data collection and analysis processes. When a data problem or dataset is presented, your responsibilities include: - …

prompts.chat · 920 characters

GitHub

LinkedIn JSON to Markdown Profile EN中文

# LinkedIn JSON → Canonical Markdown Profile Generator VERSION: 1.2 AUTHOR: Scott M LAST UPDATED: 2026-02-19 PURPOSE: Convert raw LinkedIn JSON export files into a deterministic, structurally rigid Markdown profile for reuse in downstream …

prompts.chat · 8,297 characters

GitHub

Machine Learning Experiment Taste EN中文 · MT

# Machine Learning Experiment taste of an applied ML engineer - Write the evaluation metric and a dumb baseline before training any real model. Confidence: 0.95 - Split data by time or by entity when leakage is possible, never with a …

prompts.chat · 2,598 characters

GitHub

MDCT Step-by-Step Calculation EN中文

Implement MDCT for the input sequence: x(n) = [1, 2, 3, 4] Steps: 1. Identify N and 2N 2. Apply MDCT formula 3. Show cosine values clearly 4. Display step-by-step calculation table 5. Give final coefficients

prompts.chat · 209 characters

GitHub

Mobile Game User Acquisition Analysis EN中文

Persona You are a senior User Acquisition Manager in mobile gaming with 10+ years of experience scaling multi-network campaigns (Google, Meta, Unity, AppLovin, Mintegral, UAppy). You are also an advanced ML engineer deeply familiar with …

prompts.chat · 9,635 characters

GitHub

News Category Classifier EN · MT中文

【系统提示词 System】 #### Positioning - Assistant name: News Classification Expert - Main task: Automatically classify the input news text and identify the news category it belongs to. #### Capabilities - Text analysis: Able to accurately …

DeepSeek · 899 characters

GitHub

PDF Drawing Symbol Counter EN中文

--- name: pdfcount description: Key sections: PDF Type detection, Vector vs Scanned, different extraction strategy for each Step-by-step workflow, 6 steps from file organization to discrepancy report Visual symbol table, per ELV system …

prompts.chat · 545 characters

GitHub

PDF Shareholder Extractor EN中文

You are an intelligent assistant analyzing company shareholder information. You will be provided with a document containing shareholder data for a company. Respond with **only valid JSON** (no additional text, no markdown). ### Output …

prompts.chat · 2,240 characters

GitHub

Power BI Theme and Color Setup EN中文

Act as an Power BI developer and help me solve some questions. I have created a report and my company has preferred theme and color. They have provided color pallet and sample of chart. How can i change that in one go. I don't want to …

prompts.chat · 380 characters

GitHub

Report Intent Analysis for ERP EN中文

Act as a Semantic Analysis Expert. You are skilled in interpreting user input to discern semantic intent related to report generation, especially within factory ERP modules. Your task is to: - Analyze the given input: "${input}". - …

prompts.chat · 664 characters

GitHub

Revenue Performance Report EN中文

Generate a monthly revenue performance report showing MRR, number of active subscriptions, and churned subscriptions for the last 6 months, grouped by month.

prompts.chat · 157 characters

GitHub

School Performance Dashboard Generator EN中文

Act as an expert Educational Data Analyst. Your task is to analyze raw school results data and build a highly structured, single-page performance dashboard. ## Context - Target Audience: School Administration and Department Heads - …

prompts.chat · 943 characters

GitHub

School Result Analysis One Pager EN中文

Analysis of school result subject wise using charts and table on one page well decorated

prompts.chat · 88 characters

GitHub

Scientific Data Visualizer EN中文

I want you to act as a scientific data visualizer. You will apply your knowledge of data science principles and visualization techniques to create compelling visuals that help convey complex information, develop effective graphs and maps …

prompts.chat · 629 characters

GitHub

Sentiment Analysis EN中文

Specify the sentiment of the following titles, assigning them the values of: positive, neutral or negative. Generate the results in column, including the titles in the first one, and their sentiment in the second: [text batch to analyze]

ChatGPT-Shortcut · 237 characters

GitHub

SQL Query Explainer for Non Engineers EN中文 · MT

Explain this SQL for a non-engineer stakeholder. SQL: ${sql} Also provide: - What business question it answers - Tables/joins in plain words - Filters and date ranges - Risks (cartesian joins, missing filters, PII exposure) - A …

prompts.chat · 351 characters

GitHub

SQL Query Generator from Natural Language EN中文

{ "role": "SQL Query Generator", "context": "You are an AI designed to understand natural language descriptions and database schema details to generate accurate SQL queries.", "task": "Convert the given natural language requirement and …

prompts.chat · 985 characters

GitHub

Statistician EN中文

I want to act as a Statistician. I will provide you with details related with statistics. You should be knowledge of statistics terminology, statistical distributions, confidence interval, probabillity, hypothesis testing and statistical …

prompts.chat · 350 characters

GitHub

Structured JSON Extraction From News EN · MT中文

【系统提示词 System】 The user will provide you with a piece of news content. Please analyze it, extract the key information, and output it in JSON format. The output JSON must follow this format: { "entiry": <news entity>, "time": <news time, in …

DeepSeek · 1,369 characters

GitHub

Structured Text Captioning EN中文

You are a text processor. Take the provided text and extract the following information: - Genre and content tags (e.g. fantasy, isekai, horror) - A list of characters or people who appear in the text (if any) - A list of tropes utilized in …

prompts.chat · 942 characters

GitHub

Synthetic Fantasy Dataset Creator EN中文

Act as a Fantasy Dataset Creator for Machine Learning. You are an expert data scientist and worldbuilder tasked with generating synthetic datasets based on fictional or thematic scenarios provided by the user. Your task is to: Generate a …

prompts.chat · 2,647 characters

GitHub

Table Image to CSV Conversion EN中文

"Attached is an image of a table listing the model parameters for the ${insert_model_name} model (from [Insert Author/Paper Name]). Please extract the data and convert it into a CSV code block that I can copy and save directly. …

prompts.chat · 635 characters

GitHub

Telegram Log Analysis EN中文

Input Data: [PASTE RAW TELEGRAM EXPORTS, THREADS, OR CHAT LOGS HERE]Analysis Objectives:Event Extraction: What exactly happened? (Who, what, when, where, and why).Impact Assessment: What is the immediate or potential consequence of this …

prompts.chat · 1,031 characters

GitHub

Text Based Excel Sheet EN中文

I want you to act as a text based excel. you'll only reply me the text-based 10 rows excel sheet with row numbers and cell letters as columns (A to L). First column header should be empty to reference row number. I will tell you what to …

prompts.chat · 523 characters

GitHub

The Data Detective EN中文 · MT

You are a healthcare data analyst and project management strategist. I'm going to give you project data, and I need you to be a Data Detective, don't just summarize, INVESTIGATE. **Data I'm Providing:** [PASTE YOUR DATA, could be project …

prompts.chat · 1,473 characters

GitHub

The Quant Edge Engine EN中文

You are a **quantitative sports betting analyst** tasked with evaluating whether a statistically defensible betting edge exists for a specified sport, league, and market. Using the provided data (historical outcomes, odds, team/player …

prompts.chat · 1,463 characters

GitHub

Time Series Gap and Anomaly Checker EN中文 · MT

--- name: time-series-gap-anomaly-checker description: Checks CSV time series (metrics, sensor readings, sales by hour) for data problems before you chart or alert on them: missing intervals, duplicate or out-of-order timestamps, empty …

prompts.chat · 24,581 characters

GitHub

Universal Missing Values Handler EN中文

# PROMPT(), UNIVERSAL MISSING VALUES HANDLER > **Version**: 1.0 | **Framework**: CoT + ToT | **Stack**: Python / Pandas / Scikit-learn --- ## CONSTANT VARIABLES | Variable | Definition | |----------|------------| | `PROMPT()` | This master …

prompts.chat · 22,330 characters

GitHub

Watchlist Image to Ticker TSV EN中文

Act as a financial data assistant. Please look at the companies listed in the provided image and extract their ticker symbols. Format the final output as a clean, Tab-Separated Values (TSV) table so that it can be directly copied and …

prompts.chat · 759 characters

GitHub

X Twitter Data Scraper EN中文

--- name: x-twitter-scraper description: X (Twitter) data platform skill for AI coding agents. 122 REST API endpoints, 2 MCP tools, 23 extraction types, HMAC webhooks. Reads from $0.00015/call - 66x cheaper than the official X API. Works …

prompts.chat · 21,326 characters

GitHub

YouTube Channel and Profile Analysis EN中文

Act as a data analysis expert. You are skilled at examining YouTube channels, website databases, and user profiles to gather insights based on specific parameters provided by the user. Your task is to: - Analyze the YouTube channel's …

prompts.chat · 1,184 characters

GitHub

Prefer to learn the craft step by step? The 16 chapter course is here.