markdown-viewer/skills
data-analytics
Create data pipeline and analytics architecture diagrams using PlantUML syntax with database/analytics stencil icons. Best for ETL pipelines, data lakes, real-time streaming, data warehousing, and BI dashboard design.
Installation
npx skills add markdown-viewer/skills --skill data-analytics
Similar popular skills
Related neighbors and high-traction skills in the same topics — useful to compare before installing.
Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill …
391.6K installsGuides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, Mon…
269.8K installsPrisma Postgres setup and operations guidance across Console, create-db CLI, Management API, an…
263K installsRequired reference for Prisma ORM 7 SQL driver adapter work.
258.3K installsComplete migration guide from Prisma ORM v6 to v7 covering all breaking changes.
258.1K installsPrisma Compute deployment and hosting guide. Use whenever the user mentions Prisma Compute, `pr…
253.4K installsAlso in this package
Other skills from markdown-viewer/skills · top by installs.
npx skills add markdown-viewer/skills
More details
Agent compatibility
Declared targets from SKILL.md / docs. Unmarked agents are not listed — the skill may still install via the CLI.
Repository health
main
Skill metadata
Parsed from SKILL.md frontmatter.
More metadata
- author
- Data analytics diagrams are powered by Markdown Viewer — the best multi-platform Markdown extension (Chrome/Edge/Firefox/VS Code) with diagrams, formulas, and one-click Word export. Learn more at https://docu.md
Package contents
Files included with this skill beyond the listing page.
-
skill md
SKILL.md5,299 B -
docs
SUMMARY.md239 B
History
- First seen on skills.sh
- First recorded snapshot · 3,200 installs
Videos
Tutorials, guides, and showcases specifically about this skill.
SKILL.md
Data Analytics Diagram Generator
Quick Start: Define data sources → Declare ingestion/ETL icons → Connect to storage/warehouse → Add BI/visualization → Wrap in `plantuml fence.
⚠️ IMPORTANT: Always use
`plantumlor`pumlcode fence. NEVER use`text— it will NOT render as a diagram.
Critical Rules
- Every diagram starts with
@startumland ends with@enduml - Use
left to right directionfor data pipelines (Source → Ingest → Transform → Store → Visualize) - Use
mxgraph.aws4.*stencil syntax for analytics, database, and storage icons - Default colors are applied automatically — you do NOT need to specify
fillColororstrokeColor - Use
rectangle "Zone" { ... }orpackage "Layer" { ... }for grouping pipeline stages - Directed flows use
-->, async/streaming flows use..>(dashed)
Full stencil reference: See [stencils/README.md](../uml/stencils/README.md) for 9500+ available icons.
Mxgraph Stencil Syntax
mxgraph.aws4.<icon> "Label" as <alias>
Analytics & ETL Stencils
| Category | Stencils | Purpose |
|---|---|---|
| Query Engine | athena, athenadatasource_connectors |
Serverless SQL on S3 data |
| ETL | glue, gluecrawlers, gluedatacatalog, awsgluedataquality, awsgluefor_ray |
Data integration & cataloging |
| Streaming | kinesis, kinesisdatastreams, kinesisdatafirehose, kinesisdataanalytics, kinesisvideostreams |
Real-time data streaming |
| MapReduce | emr, emrengine, emrenginemaprm3, emrenginemapr_m5 |
Big data processing (Spark, Hive) |
| Data Warehouse | redshift, redshiftra3, redshiftstreamingingestion, redshiftml |
Columnar analytics warehouse |
| Search | opensearchservicedatanode, opensearchingestion, cloudsearch |
Full-text search & log analytics |
| BI | quicksight |
Dashboards & visualizations |
| Data Lake | lakeformation, s3, glacier, glacierdeep_archive |
Governed data lake storage |
| Catalog | datazonecustomassettype, dataexchange |
Data governance & sharing |
| Streaming Kafka | msk, msk_connect |
Managed Kafka streaming |
Database Stencils
| Category | Stencils | Purpose |
|---|---|---|
| Relational | aurora, aurorainstance, rds, rdsinstance, rdsmysqlinstance, rdspostgresqlinstance |
Transactional databases |
| NoSQL | dynamodb, dynamodbtable, dynamodbglobalsecondaryindex, dynamodb_stream |
Key-value & document store |
| Graph | neptune |
Graph database |
| In-Memory | elasticache, elasticacheforredis, elasticacheformemcached |
Cache & session store |
| Document | documentdb, documentdbwithmongodb_compatibility |
Document database |
| Ledger | quantumledgerdatabase |
Immutable transaction log |
| Wide-Column | keyspaces |
Cassandra-compatible |
Connection Types
| Syntax | Meaning | Use Case |
|---|---|---|
A --> B |
Solid arrow | Batch data flow / API call |
A ..> B |
Dashed arrow | Streaming / async / CDC |
A -- B |
Solid line | Bidirectional sync |
A --> B : "label" |
Labeled connection | Describe data format or volume |
Quick Example
@startuml
left to right direction
mxgraph.aws4.s3 "Data Lake\n(S3)" as s3
mxgraph.aws4.glue "Glue\nETL" as glue
mxgraph.aws4.redshift "Redshift" as rs
mxgraph.aws4.quicksight "QuickSight" as qs
s3 --> glue
glue --> rs
rs --> qs
@enduml
Data Analytics Architecture Types
| Type | Purpose | Key Stencils | Example |
|---|---|---|---|
| Data Lake | Centralized raw data store | s3, lake_formation, glue, athena |
[data-lake.md](examples/data-lake.md) |
| Real-time Streaming | Event stream processing | kinesis, msk, lambdafunction, opensearchservice |
[real-time-streaming.md](examples/real-time-streaming.md) |
| Data Warehouse | Star-schema analytics | redshift, glue, quicksight |
[data-warehouse.md](examples/data-warehouse.md) |
| ETL Pipeline | Extract-transform-load | glue, gluecrawlers, gluedata_catalog, s3 |
[etl-pipeline.md](examples/etl-pipeline.md) |
| Log Analytics | Centralized logging | kinesisdatafirehose, opensearchservice, lambdafunction |
[log-analytics.md](examples/log-analytics.md) |
| ML Feature Store | Feature engineering pipeline | glue, s3, athena, emr |
[ml-feature-pipeline.md](examples/ml-feature-pipeline.md) |
| CDC Pipeline | Database change capture | dynamodbstreams, kinesis, lambdafunction, redshift |
[cdc-pipeline.md](examples/cdc-pipeline.md) |
| Multi-source BI | Cross-database reporting | aurora, dynamodb, redshift, quicksight |
[multi-source-bi.md](examples/multi-source-bi.md) |