skills.rest
langcore-org
langcore-orgCOMMUNITY
Explore all skills by this author →
GitHub

db-query

Query and inspect database records using Prisma Client via Node.js.

1|Updated Oct 27, 2025
Search Tags:#database#data integrity#query#prisma#data inspection#record lookup
One-click install
npx skills add https://github.com/langcore-org/united-productions-web --skill db-query-langcore-org
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-query
Source: https://github.com/langcore-org/united-productions-web/tree/main/.claude/skills/db-query
Command: npx skills add https://github.com/langcore-org/united-productions-web --skill db-query-langcore-org

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires @supabase/supabase-js, and includes scripts (resource) components.

What problem does it solve?

This Skill allows for the safe and efficient querying of database records, crucial for verifying data integrity, understanding relationships, and confirming information before critical operations like deletion or modification.

Core Features & Use Cases

  • Data Inspection: View, count, and list records across various database tables.
  • Relationship Verification: Understand how different data entities are connected.
  • Pre-operation Checks: Confirm data existence and details before performing destructive actions.
  • Use Case: Before deleting a feature, use this skill to check for any associated chat logs or prompt configurations to ensure no data is lost unexpectedly.

Quick Start

Use the db-query skill to find all records in the User table where the role is 'ADMIN'.

Frequently Asked Questions about db-query

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

FAQPage Schema
How do I inspect database records before deleting a feature?▼

Checking database records before deletion involves querying related tables like FeaturePrompt and Chat to verify existing relationships. This skill helps confirm data integrity by listing and counting associated records across multiple tables to prevent unexpected data loss.

Can I use Prisma Client to check prompt mappings and user activity?▼

Checking prompt mappings and user activity is supported by querying the SystemPrompt, FeaturePrompt, and User tables via Prisma Client. This skill runs Node.js scripts to find and list records, verifying data relationships and user roles.

Does this database query tool work with Supabase?▼

Yes, this database query tool integrates with Supabase using the @supabase/supabase-js dependency. It executes Prisma Client queries within a Node.js script to list, count, and find records across your connected database tables.

What is the best way to verify data integrity across multiple database tables?▼

Verifying data integrity across multiple database tables requires running targeted queries to list and count records. This skill inspects schemas and finds related data across tables like User, Chat, and SystemPrompt to confirm relationships before critical operations.

How do I list all admin users in my database using a Node.js script?▼

Listing all admin users in your database using a Node.js script involves querying the User table with a role filter. This skill supports finding specific records by applying filter conditions to verify user activity and roles.

What are the limitations of using Prisma Client for data inspection?▼

Using Prisma Client for data inspection is limited to querying existing schemas and records without modifying them. This skill focuses on listing, counting, and finding data across tables rather than executing destructive database operations.

Related Skills

Explore More Software Engineering Skills→
FabianrzsFabianrzs

prisma-database-setup

Configure Prisma across PostgreSQL, MySQL, SQLite, MongoDB, and SQL Server.

Community
Advanced
anderskevanderskev
20

sqlite-vec

Store and query vector embeddings in SQLite using vec0 virtual tables.

Community
Intermediate
fcakyonfcakyon
1.0k

supabase-usage

Query Supabase databases to list tables, inspect schemas, and explore relationships.

Community
Advanced
bomberoxenviosdosruedasbomberoxenviosdosruedas

prisma-client-api

Manage database queries and CRUD operations with the Prisma Client API.

Community
Advanced