Skills tagged "database" (391)

🔍 Duckdb Sql

This skill generates DuckDB SQL queries from user questions, validating against asset schemas and producing ready-to-run in-memory queries for review.

sqldatabasedataanalytics

2

🛡️ Dynamic

This skill helps you bootstrap fullstack apps with dynamic BaaS by automating init, auth, data & API integration for rapid MVPs.

fullstackbackendfrontendapi

2

🧪 Ecto Essentials

This skill enforces Ecto essentials for Elixir database work, guiding changesets, transactions, preprocessing, and proper context usage to prevent errors.

databasebackendelixirmigration

2

📋 Epic Database

This skill helps you design Prisma schemas, migrations, and SQLite with LiteFS for Epic Stack, focusing on efficient queries and multi-region readiness.

prismadatabasesqlperformance

2

🔍 Ezorm Write Yaml Mongo

This skill writes ezorm YAML schemas for MongoDB, converting domain models into validated YAML with tables, dbnames, and indexes.

databasedatabackendwriting

2

📝 Frappe Workflow Generator

This skill generates production-ready Frappe Workflows for document state management, approvals, and multi-step processes to accelerate business automation.

backendautomationpythondatabase

2

🎨 Full Stack Development

This skill helps you design and build end-to-end applications by integrating front-end interfaces with back-end services and databases.

frontendbackendfullstackapi

2

🎨 Fullstack Developer

This skill designs and implements complete full-stack systems with Next.js, React, Firebase, and Stripe, delivering production-ready apps with scalable

fullstacknextjsfirebasestripe

2

📋 Knowledge Graph Construction

This skill guides you in designing and building knowledge graphs from unstructured data, offering extraction pipelines, schema patterns, and data model

aidataanalyticsdatabase

2

🔍 Laravel Debugging Prompts

This skill helps you craft Laravel debugging prompts with complete errors, stack traces, context, and attempted solutions to accelerate fixes.

debuggingbackenddatabasecode-review

2

🐛 Laravel Packages

This skill helps you accelerate Laravel admin development by integrating Filament v4, Debugbar, and SEOTools for streamlined UI, debugging, and SEO.

backenddebuggingseofullstack

2

🔍 Lit Search

This skill helps researchers build a reproducible literature review using OpenAlex by guiding search, screening, snowballing, annotation, and synthesis.

aiautomationapidatabase

2

📋 Load Conversation

This skill loads a past Claude conversation by UUID into the current context, enabling seamless reference and context restoration.

backenddatabaseapidata

2

📋 Managed Db Services

This skill helps you configure DigitalOcean managed databases for non-PostgreSQL engines across MySQL MongoDB Valkey Kafka and OpenSearch.

databasedevopscloudpython

2

🎨 Memory Fabric

This skill orchestrates memory graph queries to extract, deduplicate, and boost cross-referenced memories for unified context.

aidataanalyticsdatabase

2

📋 Mongodb Aggregation

This skill helps you master MongoDB aggregation pipelines to transform, analyze, and report data with clear, optimized pipelines.

databaseanalyticspython

2

🐛 Mongodb Expert

This skill helps you optimize MongoDB schema, indexing, aggregation, and sharding strategies to improve NoSQL performance and design.

databaseperformancedatadebugging

2

🛡️ Mongodb Security

This skill helps you secure MongoDB deployments by configuring authentication, RBAC, TLS, encryption, and backups for compliance and resilience.

databasesecuritypythonautomation

2

🛡️ Nestjs Framework

This skill guides building scalable NestJS backends with modular architecture, dependency injection, and enterprise patterns for robust services.

backendapidatabasetesting

2

🎨 Obsidian Mermaid

This skill helps you create Obsidian-friendly Mermaid diagrams with square layouts, minimal labels, and clean rendering for reliable markdown diagrams.

pythondocsautomationdatabase

2

📝 Oceanbase Examples

This skill guides creating OceanBase SQL examples with clear structure, meaningful names, and separate results to improve documentation clarity and realism.

databasesqldatawriting

2

📋 Oceanbase Sql Optimization

This skill optimizes OceanBase SQL by guiding query writing, index design, and plan analysis for MySQL and Oracle modes.

databasesqlperformancemonitoring

2

📋 Omi Backend Patterns

This skill guides backend development for Omi conversations, memory extraction, and LangGraph integration across Firestore, Pinecone, and Redis.

backendapidatabasedata

2

🧪 Pattern Finder

This skill helps you locate and apply code patterns by surfacing precise implementation examples and conventions from the project.

backendapidatabasecode-review

2

🧪 Performance Engineer

This skill helps you profile applications, identify bottlenecks, and implement caching and load-testing strategies to improve user-perceived performance.

performancebackendfrontendapi

2

🐛 Performance Optimization

This skill helps optimize Rails performance by detecting N+1 queries, indexing gaps, and memory issues to speed up responses.

performancedebuggingdatabasesql

2

📋 Php Laravel

This skill helps you build production-ready Laravel apps by mastering Eloquent, Blade, APIs, and queues across Laravel 10.x-11.x.

backendapidatabase

2

🧪 Postgis Knowledge Patch

This skill helps you craft and optimize PostGIS 3.5+ queries by applying latest function changes, topology, and raster enhancements across spatial analyses.

sqldatabaseanalyticsperformance

2

📋 Postgres Hybrid Text Search

This skill enables hybrid text search in PostgreSQL by combining BM25 keyword search with semantic vectors using RRF for improved relevance.

databasesqldataanalytics

2

🛡️ Redis

This skill enables caching, token revocation, rate limiting, and distributed coordination with Redis to improve scalability and security.

backenddatabaseinfraperformance

2

⚙️ Redis State Management

This skill helps you master Redis state management for caching, sessions, pub/sub, and distributed locks to build scalable, real-time applications.

backenddatabasedataperformance

2

🎨 Report Generation

This skill generates comprehensive data analysis HTML reports by querying data, performing deep cause analysis, and delivering visualizations and insights.

dataanalyticssqldatabase

2

🛡️ Scaffolding Fastapi Dapr

This skill helps you scaffold production-grade FastAPI backends with SQLModel, Dapr, and JWT authentication for scalable microservices.

backendapisqldatabase

2

🛡️ Security

This skill helps you implement database security covering access control, encryption, and audit logging to protect data and meet compliance.

securitydatabasesqldata

2

🛡️ Supabase

This skill helps you implement Supabase patterns with Next.js, including SSR auth, RLS, and server-driven data access.

backendfullstackdatabasedata

2

🛡️ Supabase Audit Tables List

This skill inventories all tables exposed through the Supabase PostgREST API to reveal potential data exposure and guide targeted auditing.

securityapidatabasetesting

2

🛡️ Supabase Report

This skill generates a comprehensive Supabase security audit report with executive summary, findings, and actionable remediation guidance for stakeholders.

securityapidatabasetesting

2

🐛 Abc Backend Guide

This skill helps you navigate ABC backend development guidelines for Java/Spring Boot, RPC, database changes, debugging, and deployment.

backendjavaspringdatabase

🎨 Ably Realtime Skill

This skill helps you build real-time React/TypeScript apps using Ably channels, spaces, live objects, chat, and live sync.

frontendapidatabasedata

🛡️ Add Feature

This skill helps you add features to existing Firebase projects using TDD, emulator verification, and secure, test-first workflows.

backendclouddatabasetesting

📋 Agents Sdk

This skill helps you build persistent, stateful AI agents on Cloudflare Workers, enabling scheduling, RPC, and streaming chat with Code Mode benefits.

aicloudbackendapi

🧪 Aico Backend Task Breakdown

This skill helps you break down PM stories into layered backend tasks in strict architectural order, ensuring clarity and dependency correctness.

backendapidatabasetesting

🐛 Altinity Expert Clickhouse Audit

This skill performs a comprehensive ClickHouse diagnostic by orchestrating expert modules to reveal performance bottlenecks and actionable improvements.

databasesqldataperformance

🐛 Altinity Expert Clickhouse Connection

This skill helps validate ClickHouse connections and prepare MCP or client queries for diagnostics and analysis.

databasesqldataanalytics

🐛 Altinity Expert Clickhouse Dictionaries

This skill analyzes ClickHouse external dictionaries including configuration, memory usage, reload status, and performance to diagnose issues and optimize

databasesqldataanalytics

🛡️ Altinity Expert Clickhouse Grants

This skill diagnoses and resolves ClickHouse grant and authentication errors after upgrades, guiding minimal grants and post-upgrade compatibility checks for

databasesqlsecuritydebugging

📋 Altinity Expert Clickhouse Index Analysis

This skill analyzes ClickHouse index usage and suggests ORDER BY and projection improvements to align with query patterns and reduce scans.

databasesqldataanalytics

📋 Altinity Expert Clickhouse Kafka

This skill diagnoses ClickHouse Kafka engine health and consumer performance to reduce lag and prevent thread starvation.

databasesqldataobservability

📋 Altinity Expert Clickhouse Logs

This skill analyzes ClickHouse system logs health, TTL settings, disk usage, freshness, and cleanup to optimize retention and RCA readiness.

databasesqldataanalytics

🐛 Altinity Expert Clickhouse Memory

This skill helps diagnose ClickHouse RAM usage, OOM risks, and memory pressure, guiding you to optimize queries and configurations.

databasesqldatadebugging

🐛 Altinity Expert Clickhouse Part Log

This skill analyzes ClickHouse system.part_log to diagnose issues from high part churn, mutations, and slow merges, guiding targeted remediation.

databasesqldataanalytics

🐛 Altinity Expert Clickhouse Schema

This skill analyzes ClickHouse table designs, partitions, ORDER BY keys, and materialized views to identify anti-patterns and optimization opportunities.

databasesqldataperformance

📋 Answering Natural Language Questions With Dbt

This skill answers natural language business questions by querying dbt semantic layer, then explores models or manifests if needed to provide an accurate

aidatasqlanalytics

🎨 Arc Diagrams

This skill generates Arc-compatible architecture diagrams as JSON from user input, enabling quick visualization of systems in React apps.

frontendapidatabasecloud

📋 Atelier Python Sqlalchemy

This skill helps you implement robust Python database access with SQLAlchemy ORM patterns, including models, sessions, queries, upserts, and JSON columns.

pythondatabasesqlbackend

⚙️ Atelier Typescript Dynamodb Toolbox

This skill helps you design and query DynamoDB single-table schemas with dynamodb-toolbox v2 in TypeScript, boosting type safety and performance.

typescriptjavascriptdatabasebackend

⚙️ Ats Skill

This skill streamlines task orchestration by connecting to the ATS backend to create, claim, complete, and monitor tasks in real time.

backendapisqldatabase

🛡️ Auth Nodejs

This skill helps backend developers securely manage CloudBase authentication in Node.js by exposing caller identity, user lookups, and custom login flows.

backendcloudsecurityapi

📋 Avoid Feature Creep

This skill helps you prevent feature creep by enforcing scope, validating value, and guiding MVP decisions to ship faster.

aiplanningproductbackend

🛡️ Backend

This skill helps you design and implement robust backend APIs across Node.js, Python, Java, and Go with best practices.

backendapidatabasesecurity