Skills tagged "database" (391)

📋 Postgres Migrations

This skill helps you write safe PostgreSQL migrations that avoid blocking reads and writes by applying vetted, non disruptive patterns.

databasesqlmigrationbackend

⚙️ Postgres Query

This skill executes SQL queries against PostgreSQL containers, auto-detects instances, and supports SELECT, INSERT, UPDATE, and DELETE with safe output.

databasesqlscriptingcli

📋 Postgresql

This skill guides PostgreSQL table design by enforcing 3NF normalization, appropriate data types, indexing strategies, and safe schema evolution.

databasesqldataperformance

📋 Prisma Expand Contract

This skill enables zero-downtime Prisma migrations using the expand-and-contract pattern for renames, type changes, and non-nullable additions.

databasemigrationbackenddevops

⚙️ Prisma Orm V7 Skills

This skill helps you migrate to Prisma ORM 7 by outlining breaking changes, config migrations, and upgrade steps for a smooth transition.

backenddatabasemigrationautomation

🎨 Project Overview

This skill helps outline Santa Lucía delivery system architecture and business rules for tracking miles, ranking, and payments.

backendfrontendapidatabase

🧪 Python Patterns

This skill helps you think through Python framework choices, async patterns, type hints, and project structure to make informed, context-driven decisions.

backendapidatabaseperformance

🔍 Quarkus Panache

This skill detects and refactors Quarkus Panache ORM smells using the Repository pattern to improve performance and reduce N+1 queries.

performancerefactorcode-reviewdatabase

📋 Query

This skill helps you query Stripe synced data efficiently from PostgreSQL, optimizing joins, filters, and ORM integration.

sqldatabaseanalyticsbackend

📋 Query Builder

This skill converts natural language questions into SQL queries by analyzing schema, intents, and joins to deliver accurate data results.

databasesqldataanalytics

📋 Query Optimization

This skill analyzes SQL queries, suggests indexing and rewriting techniques to boost performance across databases.

databasesqlperformance

🐛 Query Writing

This skill helps you write and execute SQL queries across simple and complex scenarios, delivering accurate results and clear answers.

sqldataanalyticsdatabase

⚙️ Query Writing

This skill helps you write and run SQL queries, from simple single-table lookups to complex multi-table joins and aggregations.

sqldatabasedataanalytics

📝 Rag_service

This skill enables fast, multi-path semantic search with Milvus, rerank precision, and scalable document storage for large-scale knowledge retrieval.

aibackenddatabasedata

🧪 Rails Model Patterns

This skill helps you design robust Rails models with clear associations, validations, scopes, and safe migrations for maintainable apps.

backenddatabasemigrationtesting

📋 Railway

This skill helps you deploy and manage applications on Railway, including databases, private networking, and multi-service setups.

devopscloudbackenddatabase

🛡️ Rds

This skill helps you provision, configure, and optimize AWS RDS databases with best practices for backups, high availability, and security.

clouddatabasesecuritydevops

🔍 Real World Rails

This skill researches how production Rails apps solve architectural problems by examining real code patterns from the Real World Rails repository.

railsresearchbackendcode-review

📋 Reasoningbank Agentdb

This skill enables adaptive learning for self-learning agents using ReasoningBank and AgentDB, improving decision-making via memory distillation and trajectory

aibackenddatabasepython

🧪 Refactoring Expert

This skill identifies code smells and guides safe, incremental refactoring to improve structure while preserving behavior.

refactorcode-reviewtestingvue

🛡️ Relational Database Tool

This skill enables safe CloudBase Relational Database operations via MCP tools, guiding read, write, and security rule actions without using standard SDKs.

databasesqlsecuritycloud

🧪 Requirements Management

This skill guides you through managing requirements in Effect, enabling testable dependency injections via Context, Layer, and Tag services.

backendapitestingobservability

🧪 Rest Api Expert

This skill helps you design robust REST APIs with proper endpoints, HTTP semantics, versioning, error handling, pagination, and OpenAPI documentation.

apibackendperformancedocs

🧪 Ruby Rails

This skill helps you develop Rails 8 and Ruby 3.2 APIs, models, and services with best practices, tests, and performance.

railsbackendapitesting

📋 Schema Designer

This skill helps you design scalable database schemas, create tables, and model relationships with clear DDL explanations.

databasesqldatadesign

🐛 Schema Exploration

This skill helps you explore database schemas, map table relationships, and extract column details and sample data for informed queries.

sqldatabasedataanalytics

⚙️ Schemachange

This skill helps you manage Snowflake schema changes with version-controlled migrations and CI/CD pipelines for safe deployments.

databasedevopsci-cdsql

📋 Server

This skill helps you scaffold and maintain a FastAPI backend in server/ with Async SQLAlchemy, migrations, and AI tooling.

backendapifastapipython

⚙️ Setup

This skill helps you install and configure stripe-sync-engine for syncing Stripe data to PostgreSQL, guiding environment setup and runtime integration.

databasedevopsbackendapi

⚙️ Setup Timescaledb Hypertables

This skill helps you design TimescaleDB hypertables with optimal partitioning, compression, retention, and continuous aggregates to improve time-series

databasesqldataanalytics

🐛 Silk Debug

This skill helps you analyze Django Silk profiling data to debug slow requests, detect N+1 queries, and optimize database performance.

djangopythondatabaseperformance

⚙️ Skills

This skill helps you use the Upstash Redis SDK for serverless caching, sessions, rate limiting, and data structures with automatic serialization.

backenddatabaseperformancecloud

⚙️ Smart Data Query

This skill converts business requirements and a data warehouse catalog into executable, readable SQL across Hive, SparkSQL, and GaussDB.

sqldataanalyticsdatabase

🧪 Solid Queue Setup

This skill helps Rails developers configure Solid Queue for background jobs, from installation to recurring tasks, with adapters, queues, and monitoring.

backenddatabasetestingmigration

🔍 Springboot Init Skills

This skill helps you initialize Spring Boot monolithic projects with configurable tech stacks, project structure, and boilerplate templates.

backenddatabasecode-reviewdocs

📋 Sql Development

This skill helps you design efficient database schemas, write optimized SQL, and manage data operations following best practices.

databasesqldataperformance

📋 Sql Fundamentals

This skill helps you master SQL fundamentals, enabling efficient data queries, updates, and design patterns across databases.

sqldatabasedatabackend

📋 Sql Queries

This skill writes correct, performant SQL across major dialects, translating and optimizing queries for analytics, dashboards, and data pipelines.

sqldatabaseanalyticsperformance

📋 Sql Standards

This skill enforces Hive and SparkSQL compatible SQL standards, ensuring executability, clear parameterization, and dialect-aware output for data warehouses.

sqldatabasedataanalytics

🛡️ Sqladmin

This skill helps you build and tailor SQLAdmin interfaces for SQLAlchemy models in FastAPI or Starlette apps, including authentication, views, and async

backendapidatabasesql

🐛 Sqlalchemy

This skill provides comprehensive SQLAlchemy guidance to answer core, ORM, and dialect questions, helping you implement and optimize database interactions in

pythonsqldatabasebackend

⚙️ Sqlc

This skill helps you generate type-safe Go code from SQL queries with sqlc across SQLite, PostgreSQL, and MySQL.

sqldatabasebackendautomation

🛡️ Sqlcipher

This skill helps you securely manage encrypted databases with robust key derivation, rotation, and memory protection using SQLCipher.

securitydatabasesqldata

📝 Sqldown

This skill enables bidirectional markdown and SQLite workflows by importing into a dynamic schema and querying with SQL for fast document insights.

databasesqldatacli

🧪 Standards Migration

This skill guides you to create reversible, well-named migrations with zero-downtime deployment strategies and safe data transformations.

migrationdatabasesqldata

⚙️ Static Workspace Api

This skill helps you manage versioned table and KV schemas with migration workflows for safe schema evolution.

migrationdatabaseapisveltekit

🐛 Storage Format

This skill helps you understand and navigate SQLite-like on-disk storage structures, including pages, B-trees, and overflow handling.

databasesqldatadebugging

🧪 Streamlit Development

This skill helps you develop, test, and deploy Streamlit data apps on Snowflake with best practices for structure, testing, and production readiness.

pythondatatestingcloud

🛡️ Supabase

This skill helps you manage and migrate a Supabase project locally, ensuring version-controlled migrations and safe deployment to remote environments.

clidatabasemigrationdevops

⚙️ Supabase Architecture Variants

This skill helps you choose and implement Supabase architecture variants for monolith, service, or microservice setups and migrations.

backenddatabaseclouddevops

🛡️ Supabase Audit Auth Config

This skill analyzes Supabase authentication configuration for security weaknesses, generates progressive context updates, and surfaces actionable remediation.

securityapidatabasetesting

🛡️ Supabase Audit Buckets List

This skill inventories all Supabase storage buckets and configurations, highlighting public exposure and RLS gaps to strengthen storage security.

securityaiautomationapi

🛡️ Supabase Audit Rpc

This skill audits Supabase RPC functions for security issues, testing RLS bypass, SQL injection, and exposure risks to deliver actionable findings.

apisecuritydatabasesql

🛡️ Supabase Audit Tables Read

This skill verifies data exposure by reading from publicly accessible tables, evaluating RLS effectiveness, and documenting exact accessible data.

securityapidatabasedata

🛡️ Supabase Backend

This skill provides architecture and implementation guidance for Supabase-backed real-time tracking, focusing on database optimization, RLS, edge functions,

backenddatabasesqlsecurity

🛡️ Supabase Best Practices

This skill enforces Supabase best practices across security, schema design, authentication, real-time, edge functions, and performance for robust apps.

backenddatabasesecurityperformance

🛡️ Supabase Data Handling

This skill guides you to implement Supabase data handling for PII, retention, and GDPR/CCPA compliance, with secure redaction and audits.

aiautomationbackenddatabase

🛡️ Supabase Detect

This skill detects Supabase usage in a web app by analyzing domain patterns, client libraries, and API endpoints to determine project presence.

aiautomationsecurityapi

🛡️ Supabase Developer

This skill delivers end-to-end Supabase expertise in PostgreSQL, authentication, RLS, storage, edge functions, and realtime to build scalable apps.

backenddatabasefullstackapi

🛡️ Supabase Environments

This skill helps you implement and manage Supabase CLI environments across development, preview, and production with secure variable handling.

clidevopssecurityautomation