skills.rest
rnavarych
rnavarychCOMMUNITY
Explore all skills by this author →
GitHub

alpha-core:database-advisor

Advise on database selection, schema design, indexing, and query optimization.

14|3|Updated Feb 22, 2026
Search Tags:#query optimization#SQL#schema design#database#NoSQL#migration#data modeling
One-click install
npx skills add https://github.com/rnavarych/alpha-engineer --skill alpha-core-database-advisor
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: alpha-core:database-advisor
Source: https://github.com/rnavarych/alpha-engineer/tree/main/plugins/alpha-core/skills/database-advisor
Command: npx skills add https://github.com/rnavarych/alpha-engineer --skill alpha-core-database-advisor

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps you choose the right database, design efficient schemas, optimize queries, and plan migrations, saving you from costly database mistakes.

Core Features & Use Cases

  • Database Selection: Recommends databases based on data model, consistency, scale, and query patterns.
  • Schema Design: Advises on best practices for relational, document, graph, and other database types.
  • Query Optimization: Provides strategies for improving the performance of your database queries.
  • Migration Planning: Guides you through the process of migrating to new or updated database systems.
  • Use Case: You need to build a new application and are unsure whether to use PostgreSQL, MongoDB, or a vector database. This Skill will analyze your requirements and recommend the most suitable option with justifications.

Quick Start

Use the database advisor to recommend a database for a social media application prioritizing real-time feeds and user connections.

Frequently Asked Questions about alpha-core:database-advisor

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I choose the right database for my application's data model and query patterns?▼

Database selection requires analyzing your data model, consistency needs, scale, and query patterns. This advisor evaluates requirements across relational, NoSQL, graph, columnar, and vector databases to recommend suitable technologies like PostgreSQL or MongoDB with justifications.

What's the best way to optimize slow SQL queries and design efficient database schemas?▼

Query optimization and schema design depend on your specific database type. This advisor provides indexing strategies and schema best practices tailored to relational, document, graph, and other database technologies to improve overall query performance.

Can I get migration guidance for moving data between PostgreSQL, MongoDB, and Redis?▼

Migration planning across different database technologies is supported. The advisor guides you through the process of migrating to new or updated database systems, covering technologies like PostgreSQL, MongoDB, Redis, and Cassandra.

When do I need a vector database like Pinecone versus a relational or NoSQL database?▼

A vector database like Pinecone is needed for similarity search and AI embeddings, whereas relational or NoSQL databases serve structured data and flexible document models. The advisor analyzes your use case to recommend the appropriate database type.

Does this database advisor support time-series and columnar databases like ClickHouse and Cassandra?▼

Yes, the database advisor supports time-series and columnar databases. It provides selection and optimization guidance across a wide spectrum of technologies, including ClickHouse, Cassandra, and NewSQL systems like CockroachDB.

How do I plan a database migration strategy without causing downtime or data loss?▼

Planning a database migration strategy requires careful sequencing and validation. The advisor outlines migration strategies to help you transition to new database systems while mitigating risks of downtime and data loss.

Related Skills

Explore More Software Engineering Skills→
HouseGarofaloHouseGarofalo
3

database-architect-agent

Guide database architecture, data modeling, schema optimization, and query performance tuning.

Official
Advanced
dige04dige04

databases

Analyze and optimize MongoDB and PostgreSQL performance across production workloads.

Community
Intermediate
codewithlaiba28codewithlaiba28
1

sqlmodel-neon-integration

Design SQLModel ORM schemas and CRUD operations for Neon Serverless PostgreSQL.

Community
Advanced
Thanh-aperoThanh-apero
1

databases

Guide MongoDB and PostgreSQL schema design, query optimization, and performance tuning.

Community
Advanced