skills.rest
ak125
ak125COMMUNITY
Explore all skills by this author →
GitHub

vehicle-ops

Diagnose vehicle data issues and validate SQL queries via Supabase MCP.

1|Updated Nov 12, 2024
Search Tags:#compatibility#data quality#classification#automotive#vehicle data#database diagnostics
One-click install
npx skills add https://github.com/ak125/nestjs-remix-monorepo --skill vehicle-ops
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: vehicle-ops
Source: https://github.com/ak125/nestjs-remix-monorepo/tree/main/.claude/skills/vehicle-ops
Command: npx skills add https://github.com/ak125/nestjs-remix-monorepo --skill vehicle-ops

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill addresses issues with vehicle data accuracy, classification, and compatibility lookups, ensuring reliable information for automotive e-commerce platforms.

Core Features & Use Cases

  • Vehicle Diagnostics: Identifies and helps fix data inconsistencies in vehicle records.
  • V-Level Classification: Recalculates and assigns V-Level classifications for vehicle ranges.
  • Compatibility RPC: Checks and resolves vehicle-to-part compatibility issues.
  • Data Quality Checks: Audits vehicle data for common anti-patterns and errors.
  • Use Case: If a user reports that a specific car model is not showing compatible parts, this skill can diagnose the data issues, reclassify the vehicle if necessary, and ensure the compatibility system is functioning correctly.

Quick Start

Use the vehicle-ops skill to diagnose potential data issues for type ID '12345'.

Frequently Asked Questions about vehicle-ops

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I fix vehicle data inconsistencies when compatible parts are missing for a car model?▼

Vehicle data diagnostics identifies and resolves missing parts compatibility by detecting anti-patterns like missing foreign keys or incorrect data types in vehicle records. It audits the database, reclassifies the vehicle using V-Level classification, and verifies compatibility lookups via RPC.

What is V-Level classification and how does it work for vehicle ranges?▼

V-Level classification is a vehicle data categorization process that recalculates and assigns classification levels to vehicle ranges. It ensures accurate taxonomy mapping in automotive databases, preventing unnormalized text columns from causing compatibility lookup failures downstream.

How do I audit vehicle databases for common anti-patterns and unnormalized text columns?▼

Vehicle data quality checks audit automotive databases for missing foreign keys, incorrect data types, and unnormalized text columns. Using SQL queries via Supabase MCP, the process validates data manipulation and flags structural errors that degrade compatibility matching.

Can I use Supabase MCP to check vehicle-to-part compatibility and resolve lookup failures?▼

Yes, Supabase MCP executes SQL queries to run compatibility RPC checks for vehicle-to-part mapping. It validates foreign key relationships and data types within the vehicle and parts databases to ensure the compatibility system functions correctly.

Why does vehicle compatibility lookup fail when data types are incorrect in the parts database?▼

Vehicle compatibility lookups fail because incorrect data types and missing foreign keys break relational joins between vehicle and parts records. Database diagnostics identifies these anti-patterns and unnormalized text columns, resolving the structural mismatches causing the lookup failure.

What's the best way to diagnose vehicle data quality issues for a specific type ID?▼

The best way to diagnose vehicle data quality issues for a specific type ID is running a targeted database audit. The process checks V-Level classification, validates compatibility RPC outputs, and flags anti-patterns using SQL queries via Supabase MCP.

Related Skills

Explore More Software Engineering Skills→
ladinglogichqladinglogichq

schema-exploration

Identify and describe database schema elements including tables, columns, data types, and foreign keys.

Official
Intermediate
nexscope-ainexscope-ai
632

E-Commerce Feed Management

Diagnose synchronization errors and validate product feed data quality.

Official
Intermediate
marlo9981marlo9981

schema-exploration

List tables, describe columns and data types, and identify foreign keys.

Community
Intermediate
sanchezx1sanchezx1

supabase-index-creator

Create missing foreign key coverage indexes in Supabase via MCP.

Community
Intermediate