- Home
- /
- Categories
- /
- Database
Database
Database management and queries
implementing-dapper-queries
by bitwarden
Implementing Dapper repository methods and stored procedures for MSSQL at Bitwarden. Use when creating or modifying Dapper repositories, writing stored procedures, or working with MSSQL-specific data access in the server repo.
archimate
by markdown-viewer
Create enterprise architecture diagrams using PlantUML ArchiMate stdlib macros. Best for layered EA modeling (Business/Application/Technology), motivation analysis, migration planning, and TOGAF views. Uses !include <archimate/Archimate> stdlib with typed element macros and relationship macros. NOT for cloud infrastructure (use cloud skill) or network topology (use network skill).
data-analytics
by markdown-viewer
Create data analytics and data pipeline diagrams using PlantUML syntax with analytics/database stencil icons. Best for ETL pipelines, data lakes, real-time streaming, data warehousing, and BI dashboards. NOT for simple flowcharts (use mermaid) or general cloud infra (use cloud skill).
DB migrations and schema changes
by letta-ai
Workflows and commands for managing Alembic database migrations and schema changes in the letta-cloud core app, including using uv, just, LETTA_PG_URI, and switching between SQLite and Postgres.
Tech Resume Optimizer
by Paramchoudhary
Optimize resumes for software engineering, PM, and technical roles
Job Description Analyzer
by Paramchoudhary
Analyze job postings, calculate match scores, identify gaps, and create application strategy
llamaindex-agent
by a5c-ai
LlamaIndex agent and query engine setup for RAG-powered agents
chroma-integration
by a5c-ai
Chroma local vector database setup and operations for development and production
tech-doc-style-chinese
by Fenng
在撰写、改写或审阅中文技术文档、文档首页、产品文案、界面文案、Markdown 文档或接口说明时使用。采用克制、准确、可扫读的中文技术写作风格:避免第二人称和宣传腔,统一使用直角引号,在可见正文中处理中文与英文或数字的留白,不改动代码字面量、JSON 键名、URL、API 路径等机器可读内容。如项目存在专属术语、版本展示或信息架构约定,再按需读取 references/Project-Overrides.md。
spark-optimization
by wshobson
Optimize Apache Spark jobs with partitioning, caching, shuffle optimization, and memory tuning. Use when improving Spark performance, debugging slow jobs, or scaling data processing pipelines.
multi-cloud-architecture
by wshobson
Design multi-cloud architectures using a decision framework to select and integrate services across AWS, Azure, and GCP. Use when building multi-cloud systems, avoiding vendor lock-in, or leveraging best-of-breed services from multiple providers.
cqrs-implementation
by wshobson
Implement Command Query Responsibility Segregation for scalable architectures. Use when separating read and write models, optimizing query performance, or building event-sourced systems.
api-design-principles
by wshobson
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.
dbt-transformation-patterns
by wshobson
Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.
fastapi-templates
by wshobson
Create production-ready FastAPI projects with async patterns, dependency injection, and comprehensive error handling. Use when building new FastAPI applications or setting up backend API projects.
web-search
by jjyaoao
Implement web search capabilities using the z-ai-web-dev-sdk. Use this skill when the user needs to search for real-time information from the web, retrieve up-to-date content beyond the knowledge cutoff, or find the latest news and data. Returns structured search results with URLs, snippets, and metadata.
openspec-apply-change
by PBH-BTN
Implement tasks from an OpenSpec change. Use when the user wants to start implementing, continue implementation, or work through tasks.
atlas-best-practices
by NeverSight
Patterns for Atlas database schema management covering HCL/SQL schema definitions, versioned and declarative migrations, linting analyzers, testing, and project configuration. Use when working with atlas.hcl, .hcl schema files, Atlas CLI commands, or database migrations.
server-actions
by elie222
Guidelines for implementing Next.js server actions
testing
by elie222
Guidelines for testing the application with Vitest
hugging-face-datasets
by huggingface
Create and manage datasets on Hugging Face Hub. Supports initializing repos, defining configs/system prompts, streaming row updates, and SQL-based dataset querying/transformation. Designed to work alongside HF MCP server for comprehensive dataset workflows.
rerender-lazy-state
by TheOrcDev
Use lazy state initialization with useState function form. Apply when computing expensive initial values like building search indexes, parsing JSON, or complex calculations.
js-hoist-regexp
by TheOrcDev
Hoist RegExp creation outside render or memoize with useMemo(). Apply when using regular expressions in React components or frequently called functions.
get-code-context-exa
by exa-labs
Code context using Exa. Finds real snippets and docs from GitHub, StackOverflow, and technical docs. Use when searching for code examples, API syntax, library documentation, or debugging help.