Skills tagged "database" (391)

🛡️ Supabase Postgres Best Practices

This skill helps optimize Postgres queries, schemas, and configs with Supabase best practices to boost performance and security.

databasesqlperformancesecurity

4.4k

🛡️ Create Auth

This skill guides you to add robust authentication in TypeScript/JavaScript apps using Better Auth across frontend, backend, and migrations.

backendfrontendfullstacksecurity

1.6k

🧪 Nestjs Expert

This skill helps you design and implement modular NestJS backends with DI, DTOs, guards, and TypeORM or Prisma integration.

backendapidatabasetesting

523

🧪 Convex Best Practices

This skill helps you build production-ready Convex apps by applying best-practice patterns for function organization, validation, TypeScript usage, and error

backenddatabaseaidebugging

201

🛡️ Postgres Patterns

This skill helps you optimize PostgreSQL queries, schemas, and security using best practices from Supabase, boosting performance and reliability.

databasesqlperformancesecurity

190

🛡️ Go Code Review

This skill reviews Encore Go code for best practices, highlighting infrastructure placement, context usage, error handling, and security improvements to guide

code-reviewbackendsecuritydatabase

98

📋 Infrastructure

This skill helps you declare databases, Pub/Sub, cron jobs, and secrets at package level using Encore.ts for consistent local and cloud provisioning.

infradevopsclouddatabase

88

📋 Go Database

This skill helps you perform type-safe Encore Go database operations with queries, migrations, and transactions to ensure reliability.

databasesqlbackendmigration

78

📋 Project Module Architecture

This skill helps you design and navigate a Kotlin project management module, covering project lifecycle, membership, configuration, and governance.

backenddevopsapimigration

70

🧪 Http Api

This skill enables calling CloudBase HTTP APIs directly from backends without SDKs to manage database, auth, functions, storage, and more.

cloudbackendapidatabase

61

📋 Go Service

This skill helps you organize Go services in Encore by structuring packages, endpoints, and migrations for scalable microservices.

backendapidatabasemigration

57

🛡️ Database

This skill helps you manage Encore database operations, including queries, migrations, and Drizzle ORM integration for secure, efficient data access.

databasesqlbackendmigration

54

📋 Go Infrastructure

This skill helps you declare Encore Go infrastructure at package level, simplifying local and production provisioning across databases, pub/sub, and storage.

infradevopsclouddatabase

53

🎨 Spec Workflow

This skill guides structured software development from requirements to task execution using EARS syntax and UI-design references to ensure quality.

planningdesignfrontendbackend

50

🛡️ Cloudbase Platform

This skill helps you understand CloudBase platform concepts, configure authentication, deploy functions, manage databases, and optimize data models across web

cloudbackenddatabasesecurity

49

🐛 Drizzle

This skill helps you design and migrate PostgreSQL schemas with Drizzle ORM, ensuring type-safe, scalable database models and reliable migrations.

databasesqlmigrationbackend

49

🧪 Async Io Model

This skill enforces cooperative IO patterns in core Rust to reliably manage asynchronous operations with explicit state machines for correctness and

databasesqlbackenddata

45

🎨 Relational Database Web

This skill enables browser apps to initialize CloudBase Relational Database with a single shared db client and use Supabase-style queries.

cloudfrontenddatabasejavascript

41

📋 Databases

This skill helps you design and optimize MongoDB and PostgreSQL schemas, queries, and migrations for reliable, scalable data management.

databasesqldatabackend

38

🧪 Testing

This skill helps you test Encore.ts applications with Vitest, covering APIs, services, databases, and pub/sub for reliable development.

backendapitestingunit-tests

36

⚙️ Alembic

This skill guides you through Alembic database migrations for customer support systems, ensuring minimal downtime, data integrity, and safe production

databasemigrationsqldata

25

📋 Spring Data Jpa

This skill helps you implement Spring Data JPA persistence layers with repositories, queries, pagination, auditing, relationships, and multi-database

javaspringdatabasedata

24

🛡️ Sqlite

This skill helps you build secure SQLite database operations with parameterized queries, migrations, and FTS5 support for desktop apps.

databasesqlsecurityperformance

20

📋 Langchain4j Vector Stores Configuration

This skill helps configure LangChain4J vector stores for RAG applications, enabling efficient embedding storage, retrieval, and production-ready performance.

backenddatabasedataperformance

19

📝 No Sql Wx Mp Sdk

This skill helps you query, create, update, and delete CloudBase documents in WeChat MiniProgram apps with efficient, scalable database operations.

clouddatabasebackendtypescript

19

📝 Documentation Expert

This skill helps you improve documentation quality and user experience by analyzing structure, navigation, and readability and proposing actionable

docscontentuxaccessibility

17

🛡️ Aws Cloudformation Dynamodb

This skill helps you design production-ready DynamoDB infrastructure with CloudFormation, covering tables, keys, indexes, auto-scaling, encryption, TTL,

cloudawsdatabaseinfra

14

📋 Geospatial Postgis Patterns

This skill helps implement geofences, distance calculations, and real-time tracking using PostGIS to power location-based features.

databasesqldataanalytics

12

🛡️ Solodit Api Skill

This skill helps you search and filter 50,000+ smart contract vulnerabilities across major audits for rapid security insights.

securitydatabaseanalyticsapi

11

📋 Aws Sdk Java V2 Rds

This skill helps you manage AWS RDS resources using the Java v2 SDK, covering instances, snapshots, parameter groups, backups, and monitoring.

awsdatabasejavacloud

9

⚙️ Redis Development

This skill helps you optimize Redis performance and data models across RQE, vector search, and semantic caching for faster, cost-efficient apps.

performancedatabasejavascriptobservability

8

🧪 Elixir Antipatterns

This skill helps you apply Elixir anti-patterns to improve reliability, maintainability, and testing in Phoenix and Ecto projects.

backendcode-reviewtestingdatabase

7

🐛 Db Migrations Schema Changes

This skill guides managing Alembic migrations and schema changes for letta-cloud core, enabling safe Postgres or SQLite transitions and upgrades.

databasemigrationbackendsql

6

⚙️ Docs

This skill enables rapid multi-agent orchestration with MCP-B, AMUM-QCI-ETHIC, and DuckDB/SurrealDB pipelines for compliant, visual workflow automation.

aiautomationdatabasesql

5

🛡️ Pr Workflow

This skill synthesizes PR workflow guidelines for commits, PRs, CI, security, and dependencies to help teams maintain clean history and focused changes.

gitci-cdcode-reviewtesting

4

⚙️ Aws Cloudformation Rds

This skill helps you design production-ready AWS CloudFormation patterns for RDS databases, including instances, clusters, subnets, parameter groups, and

awsclouddatabasedevops

3

📋 Brain Expert

This skill helps you manage your brain CLI knowledge base, capture notes, search effectively, and organize entries across daily and named files.

cliproductivitydatadatabase

3

⚙️ Convex Agents Tools

This skill enables agents to call Convex tools, external APIs, and databases to fetch data, perform actions, and automate workflows.

aiautomationapidatabase

3

⚙️ Cosmos Dbt Fusion

This skill helps you deploy dbt Fusion projects with Cosmos by validating version, installing the Fusion binary, and configuring local execution.

datadatabasedevopscloud

3

⚙️ Data Analyst

This skill helps transform raw data into actionable insights through cleaning, analysis, visualization, reporting, and predictive modeling.

dataanalyticssqldatabase

3

📋 Database Schema Designer

This skill guides you through designing scalable SQL and NoSQL schemas, optimizing normalization, indexing, migrations, and performance for maintainable data

databasesqldataperformance

3

🎨 Gs Zod Validation

This skill helps you enforce input shape with Zod in the presentation layer, while business rules live in entities and server actions use schemas.

backendfrontendtypescriptnextjs

3

✨ Lovable

This skill helps you manage Lovable.dev projects by guiding backend deployments, migrations, and edge functions through Lovable prompts.

cloudbackenddevopsdatabase

3

📋 Redis Caching

This skill helps you implement Redis caching patterns with fail-fast, fire-and-forget writes, circuit breakers, and graceful fallback to Firestore.

backenddatabaseperformancedevops

3

🧪 Adding Dbt Unit Test

This skill guides you in creating robust dbt unit tests to validate model logic before production, ensuring reliability and preventing regressions.

databasesqltestingunit-tests

2

🛡️ Adynato Web Api

This skill helps you build robust Next.js and Node.js APIs with validation, authentication, and consistent error handling for Adynato projects.

backendapifullstackdatabase

2

⚙️ Atelier Typescript Drizzle Orm

This skill helps you design and query SQL with Drizzle ORM in TypeScript, enabling type-safe schemas, relations, migrations, and multi-database support.

databasesqltypescriptjavascript

2

🛡️ Aurora Schema

This skill analyzes and edits *.aurora.yaml files to enforce naming, descriptions, and module semantics per DDD best practices.

backenddatadatabasetypescript

2

🛡️ Backend Dev

This skill orchestrates end-to-end backend development from architecture to deployment, delivering secure, scalable APIs and automated DevOps workflows.

backendapidevopssecurity

2

📋 Backend Engineer

This skill helps backend engineers translate product requirements into robust services, data models, and scalable API design.

backendapidatabasedesign

2

🔍 Bknd Create Entity

This skill helps you create new entities in Bknd, offering UI and code-mode workflows with type-safe definitions.

backenddatabasedatacode-review

2

📋 Business Intelligence

This skill helps you master enterprise BI tools to build scalable analytics, dashboards, and self-service reporting across organizations.

dataanalyticsdatabasesql

2

🛡️ Busirocket Supabase

This skill enforces centralized Supabase access and boundary rules to prevent direct calls from components, hooks, or utils.

backenddatabasesecuritycode-review

2

⚙️ Code Style

This skill enforces Grey Haven coding standards for TypeScript, Python, and project configs, guiding formatting, naming, and multi-tenant patterns across

pythonfastapilintingformatting

2

🧪 Create Migration

This skill helps you create and apply robust database migrations in MongoDB-based apps, ensuring safe schema changes and data transformations.

migrationdatabasebackendtesting

2

📋 Data Module

This skill integrates async SQLAlchemy data access with request-scoped sessions and pool management to simplify robust database operations.

databasesqldatabackend

2

📋 Database Implementation

This skill designs and validates database schemas, migrations, and query optimization, guiding you from design to rollback with Flyway and Exposed.

databasesqlmigrationbackend

2

🛡️ Database Reviewer

This skill reviews PostgreSQL queries, schemas, security, and performance, applying Supabase best practices to optimize, secure, and scale databases.

databasesqlsecurityperformance

2

🔍 Django Perf Review

This skill performs a validated Django performance review to identify N plus 1s, unbounded queries, and missing indexes, guiding targeted optimizations.

djangoperformancedatabasebackend

2

🧪 Dotnet Webapi

This skill scaffolds and maintains .NET 10 Web API projects with CRUD, EF integration, DI, testing, and Dockerization for production-ready REST services.

apibackenddatabasetesting

2