postgresql-table-design
A comprehensive guide for designing high-performance, maintainable PostgreSQL database schemas, covering best practices, data types, indexing, and advanced features.
Discover reusable agent skills, browse implementation details, and find the right skill for your workflow.
121 skills found
A comprehensive guide for designing high-performance, maintainable PostgreSQL database schemas, covering best practices, data types, indexing, and advanced features.
Provision and manage Railway database services (Postgres, Redis, MySQL, MongoDB) with automated configuration and environment wiring.
Automate frontend API integration using Apidog and MCP servers. Generate TypeScript types, TanStack Query hooks, and axios-based clients from OpenAPI specifications for consistent, type-safe API consumption.
Expert SQL agent for modern database systems, query optimization, HTAP environments, and data architecture patterns. Optimize performance, schema design, and analytical workloads effectively.
A standardized fullstack pattern for Next.js features, integrating GET API routes, server actions, SWR data fetching, and React Hook Form with Zod validation.
Upstash Vector DB setup, semantic search, namespaces, and embedding models. Ideal for building high-performance vector search features in Next.js 16/Vercel projects.
Manage serverless messaging, task scheduling, and webhook verification with the official Upstash QStash JavaScript/TypeScript SDK.
Integration patterns and best practices for TanStack Query, Router, and Start. Ensures type-safe data flow, efficient SSR, and unified caching.
Command-line toolkit for SQL database management: schema design, query optimization, migrations, and performance debugging for SQLite, PostgreSQL, and MySQL.
NestJS 11+ expert assistant for enterprise Node.js development, including dependency injection, DTO validation, authentication, ORMs, testing, microservices, and architectural best practices.
Run, debug, and manage DBHub tests including unit, integration with Testcontainers, and database-specific suites. Perfect for verifying code changes and troubleshooting database connector issues.
Operate Railway infrastructure: manage projects, services, databases, object storage, deployments, environments, variables, logs, and performance metrics.