skills.rest
wfukatsu
wfukatsuCOMMUNITY
Explore all skills by this author →
GitHub

design-scalardb-analytics

Designs scalable hybrid transactional/analytical processing architectures using ScalarDB Analytics.

8|Updated Dec 25, 2025
Search Tags:#design#architecture#Spark#cross-database#data-catalog#HTAP#ScalarDB Analytics
One-click install
npx skills add https://github.com/wfukatsu/refactoring-agent-for-claude-code --skill design-scalardb-analytics
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: design-scalardb-analytics
Source: https://github.com/wfukatsu/refactoring-agent-for-claude-code/tree/main/.claude/skills/design-scalardb-analytics
Command: npx skills add https://github.com/wfukatsu/refactoring-agent-for-claude-code --skill design-scalardb-analytics

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

ScalarDB Analytics design agent helps architects craft scalable HTAP analytics infrastructure using ScalarDB Analytics, translating results into concrete blueprint decisions.

Core Features & Use Cases

  • Cross-DB analytics design: Outline architecture for multi-database sources and Spark-based queries.
  • Data catalog planning: Define logical/physical schemas and data lineage for analytics.
  • Query pattern design: Establish federated queries, performance optimizations, and materialized views.
  • Use Case: For a multi-DB system, design an analytics stack that can run Spark SQL against PostgreSQL, DynamoDB, and more.

Quick Start

Install and run the ScalarDB Analytics-enabled design agent against your project path, e.g. /design-scalardb-analytics [path] Review generated outputs under reports/ or analytics_design/ to verify catalog, queries, and pipeline specs.

Frequently Asked Questions about design-scalardb-analytics

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

FAQPage Schema
How do I design scalable HTAP analytics for cross-database environments?▼

Designing scalable HTAP analytics for cross-database environments requires mapping multi-database sources to a unified architecture. This skill generates a deployment-ready blueprint covering data-source mapping, Spark-based query patterns, and logical schemas for federated cross-database analytics.

What is the best way to run Spark SQL analytics across multiple databases like PostgreSQL and DynamoDB?▼

Running Spark SQL analytics across multiple databases requires a federated query architecture. This skill designs an analytical platform that establishes federated query patterns, performance optimizations, and materialized views for executing cross-database Spark SQL workloads.

How do I set up a data catalog for cross-database analytics?▼

Setting up a data catalog for cross-database analytics involves defining logical and physical schemas alongside data lineage. This skill plans comprehensive catalog schemas and data governance specifications to structure your analytics deployment.

Can I use ScalarDB Analytics to handle both transactional and analytical workloads in one architecture?▼

ScalarDB Analytics handles both transactional and analytical workloads in one architecture by applying HTAP design principles. This skill translates HTAP requirements into concrete blueprint decisions, covering data flow, governance, and Spark configuration.

What components do I need to configure for a Spark-based cross-database analytics pipeline?▼

Configuring a Spark-based cross-database analytics pipeline requires establishing query patterns, data-source mappings, and Spark configurations. This skill outputs a deployment-ready blueprint detailing pipeline specs, catalog schemas, and federated query optimizations.

Related Skills

Explore More Data & Analytics Skills→
sitharaj88sitharaj88
1

db-design

Generate database schemas with ER diagrams, normalization, and migration plans.

Community
Advanced
gugug168gugug168

clickhouse-io

Optimize ClickHouse schemas, queries, and ingestion for analytical workloads.

Community
Intermediate
i9wa4i9wa4
11

jupyter-notebook

Execute Jupyter notebooks on local Python kernels and Databricks clusters.

Community
Advanced
2025Emma2025Emma
22.7k

polymarket

Integrate Polymarket REST, WebSocket, and CLOB/GAMMA APIs into TypeScript applications.

Community
Advanced