Clickhouse Materialized Views
This skill creates ClickHouse materialized views for faster query performance by pre-computing and storing frequently accessed data results.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add clickhouse-materialized-views npx -- -y @trustedskills/clickhouse-materialized-views
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"clickhouse-materialized-views": {
"command": "npx",
"args": [
"-y",
"@trustedskills/clickhouse-materialized-views"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill enables AI agents to interact with and manage ClickHouse materialized views. It allows for the creation, alteration, and deletion of these views, which precompute query results to significantly speed up frequently executed queries. The skill facilitates efficient data aggregation and reporting within a ClickHouse environment.
When to use it
- Accelerate Reporting: Generate daily sales reports much faster by leveraging materialized views that aggregate transactional data.
- Optimize Dashboard Performance: Improve the responsiveness of dashboards displaying complex metrics derived from large datasets.
- Simplify Complex Queries: Replace intricate, slow-running queries with simpler queries against precomputed materialized views.
- Automate Data Aggregation Pipelines: Schedule and automate the refresh of materialized views to keep aggregated data up-to-date.
Key capabilities
- Create Materialized Views
- Alter Existing Materialized Views
- Delete Materialized Views
Example prompts
- "Create a materialized view named
daily_salesthat aggregates sales transactions by date." - "Refresh the materialized view called
customer_lifetime_value." - "Drop the materialized view
product_inventory_summary."
Tips & gotchas
- Requires access to a ClickHouse database and appropriate permissions to create, alter, or delete views.
- Materialized views consume storage space and require periodic refresh operations which can impact performance; plan accordingly.
Tags
TrustedSkills Verification
Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.
Security Audits
| Gen Agent Trust Hub | Pass |
| Socket | Pass |
| Snyk | Pass |
🌐 Community
Passed automated security scans.