skills.rest
Prorise-cool
Prorise-coolCOMMUNITY
Explore all skills by this author →
GitHub

data-specialist

Design databases and build ETL pipelines using SQL, Spark, Airflow, and Kafka.

24|3|Updated Jan 24, 2026
Search Tags:#database#postgresql#data analysis#data engineering#sql#etl#spark
One-click install
npx skills add https://github.com/Prorise-cool/prorise-claude-skills --skill data-specialist
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-specialist
Source: https://github.com/Prorise-cool/prorise-claude-skills/tree/main/.claude/skills/data-specialist
Command: npx skills add https://github.com/Prorise-cool/prorise-claude-skills --skill data-specialist

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines the entire data lifecycle, from designing robust databases and efficient data pipelines to extracting actionable insights through analysis.

Core Features & Use Cases

  • Database Design & Optimization: Create and refine database schemas for optimal performance and scalability.
  • Data Engineering: Build and manage reliable data pipelines for ETL/ELT processes.
  • Data Analysis: Extract meaningful insights and trends from complex datasets.
  • Use Case: You need to design a new PostgreSQL database schema for an e-commerce platform, build an Airflow DAG to ingest sales data from an API, and then analyze customer purchasing patterns to identify key segments.

Quick Start

Use the data specialist skill to design a PostgreSQL schema for an e-commerce application.

Frequently Asked Questions about data-specialist

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design and optimize a PostgreSQL database schema for scalability?▼

Designing a PostgreSQL database schema involves structuring tables and relationships for scalability. Optimization refines these schemas to ensure optimal performance during complex data operations and queries.

How do I build an ETL pipeline using Airflow and Spark?▼

Building an ETL pipeline with Airflow and Spark involves orchestrating data extraction and loading workflows. This creates reliable data pipelines that ingest and transform data efficiently for downstream analysis.

What is the best way to analyze customer purchasing patterns from a database?▼

Analyzing customer purchasing patterns requires extracting meaningful insights and trends from complex datasets. Using SQL queries against your database helps identify key customer segments based on purchasing behavior.

Does this data engineering approach support streaming architectures with Kafka?▼

Yes, this data engineering approach supports streaming architectures with Kafka. It facilitates the creation of streaming pipelines alongside batch ETL processes and data warehouses for real-time data handling.

Can I monitor data quality and optimize cloud data services using SQL?▼

Yes, you can monitor data quality and optimize cloud data services using SQL. This expertise addresses tasks related to database operations and cloud data service optimization to maintain reliable data pipelines.

Related Skills

Explore More Data & Analytics Skills→
Snowflake-LabsSnowflake-Labs
1

convert

Convert SQL from multiple database platforms into Snowflake syntax.

Official
Intermediate
liangdabiaoliangdabiao
264

ltv-predictor

Predict customer lifetime value from order data using RFM features.

Community
Advanced
HouseGarofaloHouseGarofalo
3

data-engineer-agent

Design, implement, and validate data pipelines with Spark, Airflow, and Kafka.

Official
Advanced
involvexinvolvex

data-engineering-data-pipeline

Design scalable batch and streaming data pipeline architectures with governance and monitoring.

Community
Advanced