data-specialist

Name: data-specialist
Availability: InStock
Author: prorise-cool

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

Ready to run

npx skills add https://github.com/Prorise-cool/prorise-claude-skills --skill data-specialist

💬 Prompt for ChatGPT / Claude Chat▼

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.