Quarterly Database Cleanup

Run a comprehensive quarterly CRM audit covering list health, bounce monitoring, data quality, scoring calibration, engagement metrics, and property cleanup. Produces a health report with quarter-over-quarter trend comparison.

81 stars 19 forksDatabases Plugin marketplace

Install

Claude Code plugin
/plugin marketplace add TomGranot/hubspot-admin-skills

The repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add TomGranot/hubspot-admin-skills --skill quarterly-database-cleanup
Manual install
git clone --depth 1 https://github.com/TomGranot/hubspot-admin-skills.git /tmp/hubspot-admin-skills
mkdir -p ~/.claude/skills
cp -r /tmp/hubspot-admin-skills/skills/quarterly-database-cleanup ~/.claude/skills/quarterly-database-cleanup

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# Quarterly Database Cleanup

A structured quarterly audit that catches data drift before it becomes a crisis. Run this at the start of each quarter (or monthly if the database is large or fast-growing).

## Prerequisites

- A HubSpot service key (`HUBSPOT_ACCESS_TOKEN` in `.env`; an existing legacy private app token also works)
- Python 3.10+ with [`uv`](https://github.com/astral-sh/uv)
- Previous quarter's report (for trend comparison) — optional on first run

## Audit Checklist

### 1. List Health
- Count total active lists, static lists, and unused lists (zero members)
- Identify lists not referenced by any workflow or email
- Flag duplicate or overlapping lists

### 2. Bounce Monitoring
- Count contacts with 1, 2, and 3+ bounces
- Hard bounce rate vs. previous quarter
- Review contacts flagged by bounce monitoring workflow

### 3. Data Quality
- Missing email, company, industry, country, lifecycle stage
- Compare percentages to previous quarter
- Flag any property completeness that dropped more than 5%

### 4. Scoring Calibration
- Review lead score distribution (histogram)
- Check MQL conversion rate — are high-scoring leads actually converting?
- Adjust scoring model if conversion rate is below 10% or above 50%

### 5. Engagement Metrics
- Active contacts (engagement in last 90 days) as % of total
- Zombie contacts (no engagement in 6+ months) as % of total
- Email open rate and click rate trends

### 6. Property Cleanup
- Custom properties with zero populated records
Read the full skill on GitHub

Details

Skill name
quarterly-database-cleanup
Path
skills/quarterly-database-cleanup/SKILL.md
License
MIT
Repo updated
10 November 2026

FAQ

What does the Quarterly Database Cleanup skill do?

Run a comprehensive quarterly CRM audit covering list health, bounce monitoring, data quality, scoring calibration, engagement metrics, and property cleanup. Produces a health report with quarter-over-quarter trend comparison.

How do I install the Quarterly Database Cleanup skill?

Claude Code plugin: /plugin marketplace add TomGranot/hubspot-admin-skills. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Quarterly Database Cleanup popular?

It lives in TomGranot/hubspot-admin-skills, which has 81 GitHub stars and 19 forks, and is included in 1 curated skill list.

Related skills

Assign Unowned Contacts

81

TomGranot/hubspot-admin-skills

Assign an owner to marketing contacts that have no owner. Ensures every marketable contact has accountability for follow-up, proper lead routing, and accurate owner-based reporting.

Marketing, Sales & BusinessIn 1 list19

Audit API Usage

81

TomGranot/hubspot-admin-skills

Inventory the integrations, service keys, legacy private apps, and internal tooling that call HubSpot APIs, and flag anything on legacy v1-v4 endpoints or legacy app architecture ahead of HubSpot's 2027 cutoffs. Produces a migration checklist to date-based API versions and service keys.

Software DevelopmentIn 1 list19

Backfill Geo Data

81

TomGranot/hubspot-admin-skills

Enrich missing geographic data (country, state, city) on contacts and companies using HubSpot workflows, external data providers, or IP-based geolocation.

Productivity & NotesIn 1 list19

Database Schema Visualizer

100

adriannoes/awesome-agentic-ai

Generate database schema visualizer operations. Auto-activating skill for Visual Content. Triggers on: database schema visualizer, database schema visualizer Part of the Visual Content skill category. Use when working with database schema visualizer functionality. Trigger with phrases like "database schema visualizer", "database visualizer", "database".

DatabasesIn 2 lists27

GCP Cloud SQL

213

TerminalSkills/skills

Provision and manage Cloud SQL instances on Google Cloud for MySQL, PostgreSQL, and SQL Server. Configure high availability, read replicas, automated backups, IAM database authentication, the Cloud SQL Auth Proxy, and Terraform deployments. Use for managed relational databases on GCP.

Databases34

Db Ops

43

cilangzzz/yudao-skill-pro

yudao-skill-pro 的数据库操作技能:通过解析 application.yaml 自动获取数据库凭证, 本地直连或经 badseal/ssh-skill 中转到 dev/prod 环境执行 SQL,最后通过 SQL 自检验证程序成果。 触发场景: - 用户提出"执行 SQL"、"建表"、"插入数据"、"查询数据"等 - 用户要求"验证程序成果"、"确认表结构"、"对比数据" - 任何涉及 yudao 项目数据库修改、查询、DDL、DML 的请求 实现机制: - 本技能本身不包含可执行脚本,agent 直接调用系统命令(mysql/psql/sqlplus 等) - 远程环境委托给 badseal/ssh-skill(agent 自动检测/安装)

Databases10

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.