Database

Database management and queries

Showing 2377-2400 of 3662 skills
SnakeO

debug:laravel

by SnakeO

Debug Laravel applications systematically with this comprehensive troubleshooting skill. Covers class/namespace errors, database SQLSTATE issues, route problems (404/405), Blade template errors, middleware issues (CSRF/auth), queue job failures, and cache/session problems. Provides structured four-phase debugging methodology with Laravel Telescope, Debugbar, Artisan tinker, and logging best practices for development and production environments.

CLI Tools 9 6mo ago
SnakeO

debug:django

by SnakeO

Debug Django web applications with systematic diagnostic approaches. This skill covers troubleshooting Django-specific errors including TemplateDoesNotExist, ImproperlyConfigured, IntegrityError, migration conflicts, CSRF failures, N+1 query problems, and circular imports. Includes Django Debug Toolbar setup, ORM query logging, pdb/ipdb usage, shell_plus debugging, and comprehensive logging configuration. Provides four-phase methodology for root cause analysis and regression prevention.

Code Review 9 6mo ago
SnakeO

refactor:spring-boot

by SnakeO

Refactor Spring Boot and Java code to improve maintainability, readability, and adherence to enterprise best practices. This skill transforms messy Spring Boot applications into clean, well-structured solutions following SOLID principles and Spring Boot 3.x conventions. It addresses fat controllers, improper transaction boundaries, field injection anti-patterns, and scattered configuration. Leverages Java 21+ features including record patterns, pattern matching for switch, virtual threads, and sequenced collections.

Code Gen 9 6mo ago
SnakeO

refactor:rails

by SnakeO

Refactor Ruby on Rails code to improve maintainability, readability, and adherence to best practices. This skill transforms messy Rails code into elegant, well-structured solutions following Rails conventions and modern Ruby best practices. It addresses fat controllers and models, extracts business logic into service objects, applies DRY principles, uses concerns for shared behavior, implements query objects for complex database operations, and leverages Rails 8 and Ruby 3.3+ features including pattern matching and Data classes.

Code Gen 9 6mo ago
SnakeO

refactor:laravel

by SnakeO

Refactor PHP/Laravel code to improve maintainability, readability, and adherence to best practices. This skill transforms code using modern PHP 8.3+/8.4+ features like property hooks and typed constants, Laravel 11+ patterns including Actions and simplified structure, and SOLID principles. It addresses fat controllers, code duplication, N+1 queries, and missing type declarations. Apply when you notice business logic in controllers or legacy PHP patterns.

Code Gen 9 6mo ago
SnakeO

refactor:django

by SnakeO

Refactor Django/Python code to improve maintainability, readability, and adherence to best practices. Transforms fat views, N+1 queries, and outdated patterns into clean, modern Django code. Applies Python 3.12+ features like type parameter syntax and @override decorator, Django 5+ patterns like GeneratedField and async views, service layer architecture, and PEP 8 conventions. Identifies and fixes anti-patterns including mutable defaults, bare exceptions, and improper ORM usage.

Processing 9 6mo ago
pluginagentmarketplace

react-native-state

by pluginagentmarketplace

Master state management - Redux Toolkit, Zustand, TanStack Query, and data persistence

Database 9 7mo ago
SnakeO

debug:spring-boot

by SnakeO

Debug Spring Boot issues systematically. Use when encountering bean errors like NoSuchBeanDefinitionException, circular dependency issues, application startup failures, JPA/Hibernate problems including LazyInitializationException and N+1 queries, security misconfigurations causing 403 Forbidden errors, property binding failures, CSRF token issues, or any Spring Boot application requiring diagnosis with Actuator endpoints and JVM debugging.

Code Review 9 6mo ago
amber-moe

oceanbase-examples

by amber-moe

Create SQL examples for OceanBase documentation with proper formatting, meaningful names, and separated results. Use when writing or reviewing example sections in OceanBase documentation.

Code Gen 9 6mo ago
atalovesyou

api-design-principles

by atalovesyou

Master REST and GraphQL API design principles to build intuitive, scalable, and maintainable APIs that delight developers. Use when designing new APIs, reviewing API specifications, or establishing API design standards.

API Dev 4 7mo ago
mikkelkrogsholm

surrealdb

by mikkelkrogsholm

"SurrealDB — multi-model database supporting document, graph, relational, key-value, time-series, and vector search in a single engine using SurrealQL. Use when building with SurrealDB or asking about schema design (schemafull vs schemaless), SurrealQL queries, graph relations with RELATE, live queries, full-text search, JS/TS SDK setup, namespace and database hierarchy, record IDs, authentication with DEFINE ACCESS, or connecting with WebSocket vs HTTP. Fetch live documentation for up-to-date details."

Analytics 4 5mo ago
audibleblink

google-secops-yaral

by audibleblink

Write and debug YARAL queries for behavioral threat hunting and detection in Google SecOps. Use when creating YARAL detections, hunting for network/process behavior, or learning YARAL syntax.

Code Gen 4 5mo ago
pluginagentmarketplace

big-data

by pluginagentmarketplace

Apache Spark, Hadoop, distributed computing, and large-scale data processing for petabyte-scale workloads

Processing 4 7mo ago
89jobrien

performance

by 89jobrien

Comprehensive performance specialist covering analysis, optimization,

Database 4 7mo ago
arthur0824hao

skill-system-memory

by arthur0824hao

Persistent shared memory for AI agents backed by PostgreSQL (fts + pg_trgm, optional pgvector). Includes compaction logging and maintenance scripts.

Database 4 5mo ago
DaleSeo

node-to-bun

by DaleSeo

Migrate Node.js projects to Bun with compatibility analysis. Use when converting existing npm/pnpm/yarn projects to Bun or auditing dependencies for Bun compatibility.

Processing 4 6mo ago
89jobrien

global-standards

by 89jobrien

Project-wide coding standards and conventions specialist. Use PROACTIVELY

Database 4 7mo ago
frames-engineering

open-prose

by frames-engineering

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 4 5mo ago
89jobrien

database-optimization

by 89jobrien

SQL query optimization and database performance specialist. Use when

Database 4 7mo ago
audibleblink

kql-mde-xdr

by audibleblink

Write and optimize KQL queries for Microsoft Defender (MDE), Sentinel, and Microsoft 365 Defender XDR. Use when threat hunting, writing detection rules, investigating incidents, or analyzing security data with KQL.

Processing 4 5mo ago
mikkelkrogsholm

neon

by mikkelkrogsholm

"Neon — serverless PostgreSQL with database branching, autoscaling to zero, and a serverless driver optimized for edge and serverless environments. Use when building with Neon or asking about its serverless driver, database branching, connection pooling, autoscaling configuration, compute suspend behavior, or integration with Drizzle, Prisma, or other ORMs. Fetch live documentation for up-to-date details."

API Dev 4 5mo ago
dengineproblem

Отчёты по рекламе

by dengineproblem

```

Database 4 5mo ago
TiansuYu

starrocks-expert

by TiansuYu

Expert guidance for StarRocks database operations including table management, data loading, query optimization, materialized views, partitioning strategies, and cluster configuration. Use when working with StarRocks databases, OLAP queries, data warehousing, ETL pipelines, or when the user mentions StarRocks, distributed analytics, or columnar storage.

Code Review 4 5mo ago
mikkelkrogsholm

tanstack-query

by mikkelkrogsholm

"TanStack Query — powerful async state manager for TypeScript/JavaScript with caching, background refetching, and server state synchronization. Use when building with TanStack Query (React Query) or asking about its caching, query keys, mutations, invalidation, optimistic updates, or integration with React, Vue, Solid, or Svelte. Fetch live documentation for up-to-date details."

Processing 4 5mo ago