MCP HubMCP Hub
スキル一覧に戻る

validating-database-integrity

jeremylongshore
更新日 Yesterday
69 閲覧
712
74
712
GitHubで表示
メタaiautomationdata

について

このスキルは、データベースの整合性を確保するために、データ型、範囲、形式、およびビジネスルールを自動的に検証するdata-validation-engineプラグインを使用します。マルチデータベース環境におけるデータ検証の実装、制約の適用、データ品質の向上に最適です。開発者は、本番環境対応システムにおいて「データ検証」や「データベース整合性」の要求がトリガーされた際に活用すべきです。

クイックインストール

Claude Code

推奨
プラグインコマンド推奨
/plugin add https://github.com/jeremylongshore/claude-code-plugins-plus
Git クローン代替
git clone https://github.com/jeremylongshore/claude-code-plugins-plus.git ~/.claude/skills/validating-database-integrity

このコマンドをClaude Codeにコピー&ペーストしてスキルをインストールします

ドキュメント

Overview

This skill empowers Claude to implement comprehensive data validation at both the database and application levels, ensuring data integrity and adherence to defined rules. It leverages the data-validation-engine plugin to automate the process of defining and enforcing validation rules.

How It Works

  1. Rule Definition: Claude analyzes the request and identifies the specific data validation requirements (e.g., data types, ranges, formats).
  2. Validation Implementation: Claude uses the data-validation-engine plugin to generate and apply the necessary validation rules to the database schema or application logic.
  3. Verification: Claude confirms the successful implementation of the validation rules and reports any errors or conflicts.

When to Use This Skill

This skill activates when you need to:

  • Implement data validation for a new database schema.
  • Enforce data integrity constraints on existing database tables.
  • Validate data input within an application to prevent invalid data from being stored.

Examples

Example 1: Implementing Data Type Validation

User request: "Implement data validation to ensure the 'age' column in the 'users' table is an integer."

The skill will:

  1. Use the data-validation-engine plugin to add a constraint to the 'users' table, enforcing that the 'age' column must contain integer values.
  2. Verify that the constraint is active and prevents non-integer values from being inserted into the 'age' column.

Example 2: Validating Email Format

User request: "Add data validation to ensure the 'email' column in the 'customers' table contains a valid email address format."

The skill will:

  1. Use the data-validation-engine plugin to add a constraint to the 'customers' table, using a regular expression to validate the format of the 'email' column.
  2. Test the constraint with valid and invalid email addresses to ensure it functions correctly.

Best Practices

  • Comprehensive Coverage: Validate all relevant data points to ensure complete data integrity.
  • Clear Error Messages: Provide informative error messages to users when validation fails, guiding them to correct the data.
  • Regular Review: Periodically review and update validation rules to reflect changing business requirements.

Integration

This skill integrates seamlessly with other database management and application development tools within the Claude Code ecosystem. It can be used in conjunction with schema design tools, data migration utilities, and application frameworks to ensure data integrity throughout the entire development lifecycle.

GitHub リポジトリ

jeremylongshore/claude-code-plugins-plus
パス: backups/skills-batch-20251204-000554/plugins/database/data-validation-engine/skills/data-validation-engine
aiautomationclaude-codedevopsmarketplacemcp

関連スキル

content-collections

メタ

This skill provides a production-tested setup for Content Collections, a TypeScript-first tool that transforms Markdown/MDX files into type-safe data collections with Zod validation. Use it when building blogs, documentation sites, or content-heavy Vite + React applications to ensure type safety and automatic content validation. It covers everything from Vite plugin configuration and MDX compilation to deployment optimization and schema validation.

スキルを見る

evaluating-llms-harness

テスト

This Claude Skill runs the lm-evaluation-harness to benchmark LLMs across 60+ standardized academic tasks like MMLU and GSM8K. It's designed for developers to compare model quality, track training progress, or report academic results. The tool supports various backends including HuggingFace and vLLM models.

スキルを見る

sglang

メタ

SGLang is a high-performance LLM serving framework that specializes in fast, structured generation for JSON, regex, and agentic workflows using its RadixAttention prefix caching. It delivers significantly faster inference, especially for tasks with repeated prefixes, making it ideal for complex, structured outputs and multi-turn conversations. Choose SGLang over alternatives like vLLM when you need constrained decoding or are building applications with extensive prefix sharing.

スキルを見る

polymarket

メタ

This skill enables developers to build applications with the Polymarket prediction markets platform, including API integration for trading and market data. It also provides real-time data streaming via WebSocket to monitor live trades and market activity. Use it for implementing trading strategies or creating tools that process live market updates.

スキルを見る