database-schema-designer

21.8k
davila7davila7

Design robust, scalable database schemas for SQL and NoSQL databases. Provides normalization guidelines, indexing strategies, migration patterns, constraint design, and performance optimization. Ensures data integrity, query performance, and maintainable data models.

191 days ago

ercdata

1.8k
openclawopenclaw

Store, verify, and manage AI data on the Ethereum blockchain (Base network) using the ERCData standard. Use when an agent needs to store data fingerprints on-chain, verify data integrity, create audit trails, manage access control for private data, or interact with the ERCData smart contract. Supports public and private storage, EIP-712 verification, snapshots, and batch operations.

192 days ago

validating-database-integrity

1.5k
Jeremylongshore Claude Code Plugins Plus Skills Data Validation EngineJeremylongshore Claude Code Plugins Plus Skills Data Validation Engine

This skill utilizes the data-validation-engine plugin to ensure database integrity. It automatically validates data types, ranges, formats, referential integrity, and business rules. Use this skill when you need to implement data validation, enforce constraints, or improve data quality within a database. It is triggered by requests for "data validation", "database integrity", or "validation rules". The plugin supports multi-database environments and production-ready implementations.

191 days ago

validating-api-responses

1.5k
Jeremylongshore Claude Code Plugins Plus Skills Validating Api ResponsesJeremylongshore Claude Code Plugins Plus Skills Validating Api Responses

Validate API responses against schemas to ensure contract compliance and data integrity. Use when ensuring API response correctness. Trigger with phrases like "validate responses", "check API responses", or "verify response format".

191 days ago

evernote-data-handling

1.5k
Jeremylongshore Claude Code Plugins Plus Skills Evernote Data HandlingJeremylongshore Claude Code Plugins Plus Skills Evernote Data Handling

Best practices for handling Evernote data. Use when implementing data storage, processing notes, handling attachments, or ensuring data integrity. Trigger with phrases like "evernote data", "handle evernote notes", "evernote storage", "process evernote content".

191 days ago

managing-database-tests

1.5k
Jeremylongshore Claude Code Plugins Plus Skills Managing Database TestsJeremylongshore Claude Code Plugins Plus Skills Managing Database Tests

Test database testing including fixtures, transactions, and rollback management. Use when performing specialized testing. Trigger with phrases like "test the database", "run database tests", or "validate data integrity".

191 days ago

generating-database-seed-data

1.5k
Jeremylongshore Claude Code Plugins Plus Skills Generating Database Seed DataJeremylongshore Claude Code Plugins Plus Skills Generating Database Seed Data

This skill enables the AI assistant to generate realistic test data and database seed scripts for development and testing environments. It uses faker libraries to create realistic data, maintains relational integrity, and allows configurable data volumes. Use when working with databases or data models. Trigger with phrases like 'database', 'query', or 'schema'.

192 days ago

data-migration-validator

376
a5c-aia5c-ai

Validate data integrity during and after migration with comprehensive verification checks

192 days ago

bio-imaging-mass-cytometry-quality-metrics

293
GPTomicsGPTomics

Quality metrics for IMC data including signal-to-noise, channel correlation, tissue integrity, and acquisition QC. Use when assessing data quality before analysis or troubleshooting problematic acquisitions.

192 days ago

qe-database-testing

215
proffesor-for-testingproffesor-for-testing

Database schema validation, data integrity testing, migration testing, transaction isolation, and query performance. Use when testing data persistence, ensuring referential integrity, or validating database migrations.

databaseschemamigration+4
191 days ago

database-testing

215
proffesor-for-testingproffesor-for-testing

Database schema validation, data integrity testing, migration testing, transaction isolation, and query performance. Use when testing data persistence, ensuring referential integrity, or validating database migrations.

databaseschemamigration+4
192 days ago

backend-migrations

188
aiskillstoreaiskillstore

Create and manage database schema migrations with reversibility, zero-downtime deployment support, and proper version control. Use this skill when creating database migration files, modifying schema, adding or removing tables/columns, creating indexes, managing migration rollbacks, or planning database changes. Apply when working with migration files, schema changes, database versioning, or any task involving evolving database structure over time while maintaining backwards compatibility and data integrity.

192 days ago

global-validation

188
aiskillstoreaiskillstore

Implement comprehensive server-side validation with allowlists, type checking, input sanitization, and consistent error messages, while using client-side validation for user experience. Use this skill when validating user input, form data, API requests, implementing security checks, preventing injection attacks, checking data types/formats/ranges, or providing validation feedback. Apply when working with form validation, API endpoint validation, input sanitization, business rule enforcement, or any code that accepts and validates external data to ensure security, data integrity, and proper user feedback across all entry points.

192 days ago

backend-models

188
aiskillstoreaiskillstore

Define database models and ORM entities with proper naming, relationships, validation, and data integrity constraints. Use this skill when creating or modifying model classes, database table definitions, model relationships (one-to-many, many-to-many), data validation rules, database constraints, or model methods. Apply when working with ORM model files, ActiveRecord, SQLAlchemy, Sequelize, Prisma schemas, or any database model definitions that map objects to database tables and enforce data structure and relationships.

192 days ago

data-migration

132
MicrockMicrock

Plan and execute database migrations, data transformations, and system migrations safely with rollback strategies and data integrity validation. Use when migrating databases, transforming data schemas, moving between database systems, implementing versioned migrations, handling data transformations, ensuring data integrity, or planning zero-downtime migrations.

192 days ago

database-testing

132
MicrockMicrock

Database schema validation, data integrity testing, migration testing, transaction isolation, and query performance. Use when testing data persistence, ensuring referential integrity, or validating database migrations.

192 days ago

Backend Models Standards

132
MicrockMicrock

Define database models with clear naming, appropriate data types, constraints, relationships, and validation at multiple layers. Use this skill when creating or modifying database model files, ORM classes, schema definitions, or data model relationships. Apply when working with model files (e.g., models.py, models/, ActiveRecord classes, Prisma schema, Sequelize models), defining table structures, setting up foreign keys and relationships, configuring cascade behaviors, implementing model validations, adding timestamps, or working with database constraints (NOT NULL, UNIQUE, foreign keys). Use for any task involving data integrity enforcement, relationship definitions, or model-level data validation.

192 days ago

ln-634-test-coverage-auditor

131
levnikolaevichlevnikolaevich

Coverage Gaps audit worker (L3). Identifies missing tests for critical paths (Money 20+, Security 20+, Data Integrity 15+, Core Flows 15+). Returns list of untested critical business logic with priority justification.

192 days ago

unit-test-bean-validation

128
giuseppe-trisciuogliogiuseppe-trisciuoglio

Provides patterns for unit testing Jakarta Bean Validation (@Valid, @NotNull, @Min, @Max, etc.) with custom validators and constraint violations. Validates logic without Spring context. Use when ensuring data integrity and validation rules are correct.

191 days ago

ecto-changesets

98
TheBushidoCollectiveTheBushidoCollective

Use when validating and casting data with Ecto changesets including field validation, constraints, nested changesets, and data transformation. Use for ensuring data integrity before database operations.

192 days ago

database-design

95
koralliskorallis

Design scalable, normalized database schemas with proper relationships, indexes, constraints, and migration strategies for relational and NoSQL databases. Use when designing database schemas, planning table relationships and foreign keys, creating indexes for query optimization, defining constraints and validations, designing data models for scalability, planning database migrations, choosing between SQL and NoSQL, implementing sharding strategies, optimizing query performance, or establishing data integrity rules.

192 days ago

Test Data Anonymization

71
PramodDuttaPramodDutta

Anonymizing production data for testing while maintaining referential integrity, data distributions, and edge case representation.

anonymizationdata-maskingprivacy+2
191 days ago

Data Integrity Testing

71
PramodDuttaPramodDutta

Verifying data integrity constraints, referential integrity, data type validation, and consistency checks across database operations.

data-integritydatabaseconstraints+2
191 days ago

Database Migration Test Generator

71
PramodDuttaPramodDutta

Generate tests for database migration safety covering schema changes, data integrity preservation, rollback verification, and zero-downtime migration validation

database-migrationschema-testingdata-integrity+4
191 days ago

Database Migration Testing

71
PramodDuttaPramodDutta

Testing database migration scripts for correctness, rollback safety, data integrity, and zero-downtime migration patterns.

migrationdatabaserollback+2
191 days ago

testing-dbt-models

55
AltimateAIAltimateAI

Adds schema tests and data quality validation to dbt models. Use when working with dbt tests for: (1) Adding or modifying tests in schema.yml files (2) Task mentions "test", "validate", "data quality", "unique", "not_null", or "accepted_values" (3) Ensuring data integrity - primary keys, foreign keys, relationships (4) Debugging test failures or understanding why dbt test failed Matches existing project test patterns and YAML style before adding new tests.

192 days ago

bim-consistency-checker

46
datadrivenconstructiondatadrivenconstruction

Check BIM model consistency: naming conventions, parameter completeness, spatial relationships, and data integrity across model elements.

191 days ago

computer-scientist-analyst

28
rysweetrysweet

Analyzes events through computer science lens using computational complexity, algorithms, data structures, systems architecture, information theory, and software engineering principles to evaluate feasibility, scalability, security. Provides insights on algorithmic efficiency, system design, computational limits, data management, and technical trade-offs. Use when: Technology evaluation, system architecture, algorithm design, scalability analysis, security assessment. Evaluates: Computational complexity, algorithmic efficiency, system architecture, scalability, data integrity, security.

192 days ago

data-management

24
dralgorhythmdralgorhythm

Design and manage data storage effectively. Use when working with databases, schemas, or data migrations. Covers schema design, migrations, and data integrity.

191 days ago

erpnext-errors-database

23
OpenAEC-FoundationOpenAEC-Foundation

Error handling patterns for ERPNext/Frappe database operations. Use when handling DoesNotExistError, DuplicateEntryError, transaction failures, and query errors. Covers retry patterns and data integrity. V14/V15/V16 compatible. Triggers: database error, DoesNotExistError, DuplicateEntryError, transaction failed, query error.

191 days ago

xlsx-editor

18
Exploration-labsExploration-labs

Specialized guidance for editing EXISTING Excel files with emphasis on preserving formulas, formatting, and structure across multiple tabs. Use this skill when modifying, updating, or adding data to existing .xlsx files where maintaining integrity is critical—particularly for multi-tab workbooks, complex formulas, formatted tables, and data that must maintain sort order and relationships across sheets.

191 days ago

kysely-sqlite-builder

17
subframe7536subframe7536

Utility layer for Kysely on SQLite databases. Use when working with SQLite via Kysely for: schema definition and auto-migration, soft-delete patterns, precompiled queries, pagination, nested transactions using savepoints, SQLite pragma utilities (integrity check, foreign keys, optimization), serialization/deserialization, enhanced logging. Also use when user asks about kysely-sqlite-builder library usage, table definitions, syncDB, generateMigrateSQL, parseExistSchema, or any related functionality.

191 days ago

pooch

13
SteadfastAsArtSteadfastAsArt

Data file fetching and caching for geoscience applications. Download sample datasets with automatic caching, checksum verification, and multiple download sources. Use when Claude needs to: (1) Download datasets from URLs or DOIs, (2) Cache files locally with automatic verification, (3) Verify file integrity with SHA256/MD5 hashes, (4) Extract compressed archives (ZIP, TAR, GZIP), (5) Create data registries for reproducible workflows, (6) Fetch from Zenodo or other repositories.

Data DownloadCachingReproducibility+5
191 days ago

typo3-datahandler

12
dirnbauerdirnbauer

Expert guidance on manipulating TYPO3 records via the DataHandler, ensuring transactional safety, PSR-14 event handling, and reference index integrity. Use when working with database, datahandler, tcemain, records, content, pages.

191 days ago

data-integrity-auditor

12
patricio0312revpatricio0312rev

Detects data integrity issues including orphaned records, broken foreign key relationships, constraint violations, and provides automated fix migrations. Use for "data integrity", "orphaned records", "broken relationships", or "data quality".

191 days ago

realitycheck-validate

10
lhllhl

Validate Reality Check database integrity and referential consistency. Run after adding data or before committing.

191 days ago

validate

10
lhllhl

Validate Reality Check database integrity and referential consistency. Run after adding data or before committing.

191 days ago

validating-api-responses

8
BbgnsurfTechBbgnsurfTech

Validate API responses against schemas to ensure contract compliance and data integrity. Use when ensuring API response correctness. Trigger with phrases like "validate responses", "check API responses", or "verify response format".

191 days ago

managing-database-tests

8
BbgnsurfTechBbgnsurfTech

Database testing including fixtures, transactions, and rollback management. Use when performing specialized testing. Trigger with phrases like "test the database", "run database tests", or "validate data integrity".

191 days ago

db-enforcer

8
YuniorGlezYuniorGlez

Guardian of Database Integrity. Architect of High-Performance PostgreSQL & Prisma 7 Systems. Expert in PostgreSQL 18, TypedSQL, and Zero-Trust RLS.

191 days ago

validating-database-integrity

8
BbgnsurfTechBbgnsurfTech

Use when you need to ensure database integrity through comprehensive data validation. This skill validates data types, ranges, formats, referential integrity, and business rules. Trigger with phrases like "validate database data", "implement data validation rules", "enforce data integrity constraints", or "validate data formats".

191 days ago

troubleshoot

8
thedotmackthedotmack

Diagnose and fix rad-mem installation issues. Checks PM2 worker status, database integrity, service health, dependencies, and provides automated fixes for common problems.

191 days ago

Knack Data Cleaner

7
willsigmonwillsigmon

Ensures accuracy for HTI compliance and performance dashboards through data validation, deduplication, normalization, and integrity checks. Critica...

191 days ago

healthsim-membersim

7
mark64oswaldmark64oswald

MemberSim generates realistic synthetic claims and payer data for testing claims processing systems, payment integrity, and benefits administration.

191 days ago

architecture-reviewer

6
Mathews-TomMathews-Tom

Architecture reviews across 7 dimensions: structural integrity, scalability, enterprise readiness (SOC2/HIPAA/GDPR/PCI-DSS), performance, security, operational excellence, and data architecture. Produces scored reports with prioritized recommendations. Three modes: (1) Codebase review — evidence-based analysis of source code, configs, IaC; (2) Document review — risk-based analysis of design docs, RFCs, specs; (3) Hybrid — drift detection between intent and implementation. Triggers on: "review architecture", "critique design", "audit system", "evaluate codebase", "find design flaws", "assess scalability", "check security", "enterprise readiness", "architecture assessment", "technical due diligence", or when user provides a system design document or codebase and asks for feedback or improvements.

191 days ago

security

6
dhruvanbhalaradhruvanbhalara

Security & Data Integrity (Architect Level)

191 days ago

gplay-submission-checks

6
tamtomtamtom

Pre-submission validation for Google Play releases covering metadata, screenshots, bundle integrity, data safety, and policy compliance. Use when preparing a release to avoid rejections and catch issues before submitting.

191 days ago

fault-injection-testing

4
apankov1apankov1

Simulates storage and network failures for resilience testing. Provides a circuit breaker state machine, retry policies with backoff, and queue-preservation assertions. Includes utilities (createFaultScenario, createFaultInjector), a CircuitBreaker state machine (closed/open/half-open), a configurable RetryPolicy with backoff, and assertions (assertQueuePreserved/assertQueueTrimmed) to validate data integrity. Typical workflow: enumerate fault scenarios, inject failures against external dependencies, validate circuit-breaker transitions and backoff timing, and assert transactional/idempotent behavior and queue handling. Use cases: validating retry and rollback logic, protecting microservices from cascading failures, verifying queuing guarantees, and testing third-party API error handling. Avoid applying it to pure functions or UI-only components. Core advantages: uncover edge-case failures, prove resilience quantitatively, and reduce production incidents by exercising realistic fault modes.

191 days ago