skills.rest
shekerkamma
shekerkammaCOMMUNITY
Explore all skills by this author →
GitHub

archaeology

Retrieve production-tested SQL query patterns and reusable Common Table Expressions.

Updated May 22, 2026
Search Tags:#database#data analysis#sql#cte#query templates#reusable queries#analytical sql
One-click install
npx skills add https://github.com/shekerkamma/peopletech-marketplace --skill archaeology-shekerkamma
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: archaeology
Source: https://github.com/shekerkamma/peopletech-marketplace/tree/main/plugins/ai-analyst/skills/ai-analyst/archaeology
Command: npx skills add https://github.com/shekerkamma/peopletech-marketplace --skill archaeology-shekerkamma

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Manually writing and debugging SQL queries and Common Table Expressions (CTEs) from scratch is time-consuming and error-prone, especially for common analytical tasks that have well-established, proven patterns.

Core Features & Use Cases

  • Proven SQL Pattern Library: Access pre-vetted, production-tested SQL query templates for frequent analytical operations like aggregations, joins, and time-based filtering.
  • Reusable CTE Repository: Pull ready-to-use Common Table Expressions for complex logic such as cohort calculations, data transformation, and user segmentation.
  • Use Case: When building a monthly active user cohort analysis, use this skill to grab a pre-built retention CTE instead of writing the time-window logic from scratch, cutting query development time significantly.

Quick Start

Use the ask-question or run-analysis skill to retrieve the relevant SQL pattern or reusable CTE for your current database query task.

Frequently Asked Questions about archaeology

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

FAQPage Schema
How do I write SQL queries for cohort analysis without starting from scratch?▼

You can use this skill to retrieve pre-vetted, production-tested SQL query patterns and reusable Common Table Expressions (CTEs) for cohort analysis, eliminating manual query development time and reducing errors from hand-crafted logic.

What are reusable CTEs and when do I need them for data transformation?▼

Reusable CTEs are pre-built Common Table Expressions for complex logic like cohort calculations and user segmentation. You need them when building reporting or data transformation workflows to avoid writing time-window logic from scratch.

Can I get ready-to-use SQL query templates for aggregations and joins?▼

Yes, you can instantly access a library of proven SQL query templates for frequent analytical operations including aggregations, joins, and time-based filtering to serve your data analysis tasks.

Does this SQL pattern repository work for business intelligence reporting workflows?▼

Yes, this serves data analysts, business intelligence engineers, and data engineers working on reporting, cohort analysis, and data transformation workflows by providing ready-to-use code snippets.

What is the best way to find analytical SQL patterns for user segmentation?▼

The best way is retrieving pre-vetted SQL patterns and reusable CTEs designed for analytical database tasks. This approach provides ready-to-use code snippets for user segmentation instead of manually debugging SQL.

Related Skills

Explore More Data & Analytics Skills→
JeffallanJeffallan
10.9k

sql-pro

Optimize SQL queries and schemas across PostgreSQL, MySQL, SQL Server, and Oracle.

Community
Advanced
BirdywenBirdywen
1

sqlite-data

Create, query, analyze, and export SQLite data via the sqlite3 CLI.

Community
Intermediate
seanyofthedeadseanyofthedead

building-streamlit-dashboards

Automate Streamlit dashboard creation with KPI displays and data visualization.

Community
Intermediate
luongldptitluongldptit

postgres-patterns

Diagnose PostgreSQL performance, schema, and security configuration issues.

Community
Intermediate