Database

Database management and queries

Showing 73-96 of 3621 skills
affaan-m

jpa-patterns

by affaan-m

JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot.

Code Gen 205.5K 3mo ago
affaan-m

django-verification

by affaan-m

"Verification loop for Django projects: migrations, linting, tests with coverage, security scans, and deployment readiness checks before release or PR."

Code Review 204.9K 3mo ago
affaan-m

python-testing

by affaan-m

Python testing strategies using pytest, TDD methodology, fixtures, mocking, parametrization, and coverage requirements.

Auth 204.8K 3mo ago
oliver-kriska

deploy

by oliver-kriska

Elixir/Phoenix deployment patterns - releases, Docker, Kubernetes, Fly.io. Load when deploying to production.

CI/CD 396 3mo ago
oliver-kriska

phx:challenge

by oliver-kriska

Challenge mode reviews - rigorous questioning before approving changes. Use when you want thorough scrutiny of Ecto changes, LiveView events, or PR readiness.

Code Gen 396 3mo ago
AgriciDaniel

seo

by AgriciDaniel

Comprehensive SEO analysis for any website or business type. Performs full site audits, single-page deep analysis, technical SEO checks (crawlability, indexability, Core Web Vitals with INP), schema markup detection/validation/generation, content quality assessment (E-E-A-T framework per Dec 2025 update extending to all competitive queries), image optimization, sitemap analysis, and Generative Engine Optimization (GEO) for AI Overviews, ChatGPT, and Perplexity citations. Analyzes AI crawler accessibility (GPTBot, ClaudeBot, PerplexityBot), llms.txt compliance, brand mention signals, and passage-level citability. Industry detection for SaaS, e-commerce, local business, publishers, agencies. Triggers on: "SEO", "audit", "schema", "Core Web Vitals", "sitemap", "E-E-A-T", "AI Overviews", "GEO", "technical SEO", "content quality", "page speed", "structured data".

Accessibility 8K 3mo ago
AgriciDaniel

seo-competitor-pages

by AgriciDaniel

Generate SEO-optimized competitor comparison and alternatives pages. Covers "X vs Y" layouts, "alternatives to X" pages, feature matrices, schema markup, and conversion optimization. Use when user says "comparison page", "vs page", "alternatives page", "competitor comparison", or "X vs Y".

Database 8K 3mo ago
AgriciDaniel

seo-schema

by AgriciDaniel

Detect, validate, and generate Schema.org structured data. JSON-LD format preferred. Use when user says "schema", "structured data", "rich results", "JSON-LD", or "markup".

Processing 8K 3mo ago
forcedotcom

apex-class

by forcedotcom

Generate production-ready Apex classes for Salesforce following enterprise best practices. Covers service classes, selectors, domain classes, batch/queueable/schedulable, DTOs, utilities, interfaces, abstract classes, and custom exceptions. Not for triggers or unit tests. Use this skill whenever the user asks to create, write, build, generate, or scaffold any Apex class — including when they describe functionality that would require an Apex class without explicitly saying "Apex class." Trigger on phrases like "build a service for," "create a handler," "I need a class that," "write Apex to," "scaffold a batch job," "create a queueable," or any request involving Salesforce server-side logic. Also use when the user asks to refactor, improve, or restructure existing Apex classes. Even if the request is vague like "I need something that processes Opportunities nightly," use this skill if the solution would involve an Apex class.

Automation 475 3mo ago
oliver-kriska

compound-docs

by oliver-kriska

Searchable solution documentation system with YAML frontmatter. Builds institutional knowledge from solved problems. Use proactively when consulting past solutions before investigating new issues.

Database 396 3mo ago
oliver-kriska

ecto-constraint-debug

by oliver-kriska

Debug Ecto constraint violations - trace triggers, check migrations, find duplicate data. Use when seeing unique_constraint, foreign_key_constraint, or check_constraint errors.

Database 395 3mo ago
aaron-he-zhu

schema-markup-generator

by aaron-he-zhu

'Use when the user asks to "add schema markup", "generate structured data", "JSON-LD", "rich snippets", "FAQ schema", "add FAQ rich results", "I want star ratings in Google", "product markup", or "recipe schema". Generates structured data markup (Schema.org JSON-LD) to enable rich results in search engines including FAQ snippets, How-To cards, Product listings, Reviews, and more. For meta tag optimization, see meta-tags-optimizer. For broader technical SEO, see technical-seo-checker.'

Database 2K 3mo ago
openprose

open-prose

by openprose

OpenProse is a programming language for AI sessions. Activate on ANY prose command (prose boot, prose run, prose compile, prose update, etc.), running .prose files, mentioning OpenProse/Prose, or orchestrating multi-agent workflows. The skill intelligently interprets what the user wants.

CLI Tools 1.4K 4mo ago
elie222

server-actions

by elie222

Guidelines for implementing Next.js server actions

Processing 11.1K 3mo ago
elie222

testing

by elie222

Guidelines for testing the application with Vitest

Database 11.1K 3mo ago
elie222

prisma

by elie222

How to use Prisma

Database 11.1K 3mo ago
NousResearch

pinecone

by NousResearch

Managed vector database for production AI applications. Fully managed, auto-scaling, with hybrid search (dense + sparse), metadata filtering, and namespaces. Low latency (<100ms p95). Use for production RAG, recommendation systems, or semantic search at scale. Best for serverless, managed infrastructure.

Database 178.5K 3mo ago
team-telnyx

telnyx-storage-go

by team-telnyx

Manage cloud storage buckets and objects using the S3-compatible Telnyx Storage API. This skill provides Go SDK examples.

Processing 176 3mo ago
NousResearch

chroma

by NousResearch

Open-source embedding database for AI applications. Store embeddings and metadata, perform vector and full-text search, filter by metadata. Simple 4-function API. Scales from notebooks to production clusters. Use for semantic search, RAG applications, or document retrieval. Best for local development and open-source projects.

Database 178.3K 3mo ago
ruvnet

V3 Memory Unification

by ruvnet

"Unify 6+ memory systems into AgentDB with HNSW indexing for 150x-12,500x search improvements. Implements ADR-006 (Unified Memory Service) and ADR-009 (Hybrid Memory Backend)."

Database 70.5K 4mo ago
neilotoole

sq

by neilotoole

Guides use of the sq CLI to query SQL databases and tabular files with SLQ (sq's jq-like query language) or native SQL, manage sources, choose output formats, and run inspect, diff, and table commands. Use when the user mentions sq, SLQ, wrangling CSV/Excel/JSON/DB data, cross-source joins, or command-line data pipelines after installing sq from https://sq.io.

Processing 2.5K 1mo ago
mfts

postgres

by mfts

PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement. Load when working with Postgres databases.

CLI Tools 8.5K 3mo ago
Paramchoudhary

Tech Resume Optimizer

by Paramchoudhary

Optimize resumes for software engineering, PM, and technical roles

Processing 670 4mo ago
AgriciDaniel

blog-schema

by AgriciDaniel

Generate complete JSON-LD schema markup for blog posts including BlogPosting, Person, Organization, BreadcrumbList, FAQPage, and ImageObject. Validates against Google requirements and warns about deprecated types. Use when user says "schema", "blog schema", "json-ld", "structured data", "schema markup", "generate schema".

Database 953 3mo ago