Help us improve
Share bugs, ideas, or general feedback.
Share bugs, ideas, or general feedback.
Share bugs, ideas, or general feedback.
By yu-iskw
Agent skills for adopting and tuning sqlfluff-complexity CPX rules in SQLFluff and dbt projects.
npx claudepluginhub yu-iskw/sqlfluff-complexity --plugin sqlfluff-complexitySQLFluff rules and reports for finding SQL and dbt models that are too complex to review safely.
sqlfluff-complexity adds CPX rules to SQLFluff for CTE count, join count, nested
subquery depth, CASE expressions, nested CASE depth, boolean predicates, window functions,
CTE dependency depth, set operations (UNION / INTERSECT / EXCEPT), inline derived tables, and
an aggregate weighted complexity score. The same metric engine also powers a companion
sqlfluff-complexity report command for non-blocking console, JSON, SARIF, and standalone
HTML reports.
Requires SQLFluff 4.x in the same environment (sqlfluff>=4,<5). SQLFluff 3 is not supported as of sqlfluff-complexity 0.4.0; pin sqlfluff-complexity<0.4 if you cannot upgrade SQLFluff yet.
Install the custom SQLFluff plugin in the same Python environment where you run SQLFluff:
pip install sqlfluff-complexity
If your project uses uv:
uv add --dev sqlfluff-complexity
Then enable CPX rules in .sqlfluff and run SQLFluff:
[sqlfluff]
dialect = postgres
rules = CPX_C101,CPX_C102,CPX_C103,CPX_C104,CPX_C105,CPX_C106,CPX_C107,CPX_C108,CPX_C109,CPX_C110,CPX_C201
sqlfluff lint models/
For a complete walkthrough, see docs/quickstart.md.
Migrating complexity_weights: Use a JSON object in [sqlfluff:rules:CPX_C201] (not comma-separated key:value lists). See Configuration: aggregate score and CHANGELOG.
path_overrides.report pipeline and related config helpers; more subcommands documented here as they ship).sqlfluff_complexity.core submodules directly, update paths after subpackage refactors.This plugin does not read dbt artifacts (manifest.json, run_results.json, catalog.json) or graph metadata. Complexity is measured from the SQLFluff parse tree only—which aligns well with SQLFluff’s dbt templater so ref(), source(), and macros compile before linting.
Practical adoption patterns:
sqlfluff-complexity focused on structural signals from parsed SQL.path_overrides on CPX_C201 where staging vs marts need different budgets.sqlfluff lint on changed models in CI and sqlfluff-complexity report for broader visibility without failing builds.WITH lint).See also dbt usage and configuration.
manifest.json and DAG-level metrics are deferred.Contributor setup, Nox sessions, fixture authoring, ADR workflow, and verifier guidance live in CONTRIBUTING.md. Agent-specific project instructions live in AGENTS.md.
Share bugs, ideas, or general feedback.
Based on adoption, maintenance, documentation, and repository signals. Not a security audit or endorsement.
Comprehensive skill pack with 66 specialized skills for full-stack developers: 12 language experts (Python, TypeScript, Go, Rust, C++, Swift, Kotlin, C#, PHP, Java, SQL, JavaScript), 10 backend frameworks, 6 frontend/mobile, plus infrastructure, DevOps, security, and testing. Features progressive disclosure architecture for 50% faster loading.
Manus-style persistent markdown files for planning, progress tracking, and knowledge storage. Works with Claude Code, Kiro, Clawd CLI, Gemini CLI, Cursor, Continue, Hermes, and 17+ AI coding assistants. Now with Arabic, German, Spanish, and Chinese (Simplified & Traditional) support.
Intelligent draw.io diagramming plugin with AI-powered diagram generation, multi-platform embedding (GitHub, Confluence, Azure DevOps, Notion, Teams, Harness), conditional formatting, live data binding, and MCP server integration for programmatic diagram creation and management.
Complete creative writing suite with 10 specialized agents covering the full writing process: research gathering, character development, story architecture, world-building, dialogue coaching, editing/review, outlining, content strategy, believability auditing, and prose style/voice analysis. Includes genre-specific guides, templates, and quality checklists.
Payload Development plugin - covers collections, fields, hooks, access control, plugins, and database adapters.
Write SQL, explore datasets, and generate insights faster. Build visualizations and dashboards, and turn raw data into clear stories for stakeholders.
Agent skills and subagents for automating GitHub issues, project boards, and workflows using the GitHub CLI.
Lightdash Organization Administration plugin for managing users, groups, and organization settings.
Lightdash Development plugin for semantic layer modeling (dbt YAML, metrics, dimensions).
Lightdash Content Administration plugin for managing spaces, charts, and dashboards within a project.
Agent team plugin for software development with 3-tier pipeline: Plan → Research/Orchestrate → Parallel execution. Provides 11 specialized agents (planner, orchestrator, product-manager, designer, software-engineer, code-reviewer, qa, sre-devops, security, legal-compliance, researcher) and 11 matching skills for collaborative development workflows.
Own this plugin?
Verify ownership to unlock analytics, metadata editing, and a verified badge.
Sign in to claimOwn this plugin?
Verify ownership to unlock analytics, metadata editing, and a verified badge.
Sign in to claim