skills.rest
captainflasmr
captainflasmrCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-specialist

Design SQL schemas, optimize queries, and construct safe SQL statements.

100|9|Updated Feb 6, 2025
Search Tags:#design#database#postgresql#optimization#queries#sql
One-click install
npx skills add https://github.com/captainflasmr/ollama-buddy --skill database-specialist-captainflasmr
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-specialist
Source: https://github.com/captainflasmr/ollama-buddy/tree/main/.agents/skills/database-specialist
Command: npx skills add https://github.com/captainflasmr/ollama-buddy --skill database-specialist-captainflasmr

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Database design, optimization, and query construction across SQL databases are streamlined to deliver fast, secure, and scalable data solutions.

Core Features & Use Cases

  • Guidance on schema design and normalization principles for MySQL, PostgreSQL, SQLite, and others.
  • Strategies for indexing, query tuning, and performance optimization with practical examples.
  • Security considerations including prevention of SQL injection and secure access patterns.
  • Use case examples such as designing a normalized ecommerce schema, optimizing a reporting analytics query, or refactoring a legacy database for scalability.

Quick Start

Design a normalized PostgreSQL schema for an ecommerce catalog including products, categories, customers, and orders, with indexing recommendations.

Frequently Asked Questions about database-specialist

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

FAQPage Schema
How do I design a normalized PostgreSQL schema for an ecommerce catalog?▼

Database optimization for SQL systems involves analyzing execution plans, adding targeted indexes, and rewriting queries to reduce latency. It speeds up reporting analytics queries and refactors legacy databases for better scalability.

How do I optimize slow SQL queries in MySQL and PostgreSQL?▼

Yes, schema design and normalization principles apply to PostgreSQL, MySQL, SQLite, and other SQL engines. You receive guidance on data models, indexing, and safe query practices tailored to your specific SQL database system.

Does this database optimization approach work with SQLite and MySQL?▼

Database optimization for SQL systems involves analyzing execution plans, adding targeted indexes, and rewriting queries to reduce latency. It speeds up reporting analytics queries and refactors legacy databases for better scalability.

What is the best way to prevent SQL injection when constructing queries?▼

To design a normalized PostgreSQL schema, structure products, categories, customers, and orders into separate tables to eliminate data redundancy. This approach ensures data integrity and provides indexing recommendations for fast, scalable query performance.

When do I need database refactoring for scalability?▼

You need database refactoring for scalability when legacy schemas cause performance bottlenecks or slow reporting analytics. Refactoring involves normalizing data models and adding strategic indexes to support fast, scalable SQL queries.

Related Skills

Explore More Software Engineering Skills→
UnicornUnicorn

db-design-agent

Design database schemas and data models for relational and NoSQL applications.

Official
Intermediate
cornmanwtfcornmanwtf

sql-query-optimizer

Analyze SQL query execution plans and identify performance bottlenecks.

Community
Intermediate
EIS-ITSEIS-ITS

Backend Queries

Generate secure, optimized database queries with parameterized statements, eager loading, indexing, and transactions.

Official
Intermediate
AnasAhmed001AnasAhmed001
1

database-specialist

Design scalable SQL and NoSQL database schemas with migrations and indexing.

Community
Advanced