skills.rest
Aveer
AveerCOMMUNITY
Explore all skills by this author →
GitHub

zeus-sql

Provide SQL syntax, schema design, and ORM guides for SQLite, PostgreSQL, and MySQL.

1|Updated Mar 21, 2026
Search Tags:#database#postgresql#schema#sqlite#sql#orm
One-click install
npx skills add https://github.com/Aveer/OpenZeus --skill zeus-sql
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: zeus-sql
Source: https://github.com/Aveer/OpenZeus/tree/main/skills/zeus-sql
Command: npx skills add https://github.com/Aveer/OpenZeus --skill zeus-sql

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill addresses the complexity of writing efficient database queries and designing robust schemas by providing a centralized, high-quality reference for SQL syntax and ORM best practices.

Core Features & Use Cases

  • Query Optimization: Access patterns for complex joins, aggregations, and window functions across multiple SQL dialects.
  • Schema Design: Implement standard patterns for users, orders, and many-to-many relationships with proper indexing.
  • ORM Integration: Quickly reference implementation patterns for SQLAlchemy, Prisma, and Drizzle to bridge the gap between application code and database layers.

Quick Start

Use the zeus-sql skill to generate a schema definition for a new users table including timestamps and unique constraints.

Frequently Asked Questions about zeus-sql

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

FAQPage Schema
How do I design a database schema with many-to-many relationships and proper indexing?▼

Database schema design for many-to-many relationships requires junction tables with proper indexing. This skill provides standard schema patterns for users and orders, ensuring robust relational structures and efficient data retrieval across PostgreSQL, SQLite, and MySQL.

What is the best way to optimize SQL queries using window functions?▼

SQL query optimization using window functions involves accessing specific patterns for complex aggregations. This skill provides access patterns for advanced window functions and joins, facilitating performance tuning across multiple SQL dialects.

Can I use ORM patterns to bridge application code and database layers?▼

ORM patterns bridge application code and database layers by referencing implementation guides for SQLAlchemy, Prisma, and Drizzle. This skill supports application-level data access layer development by mapping object-oriented code to relational database structures.

Does this SQL reference support both basic CRUD operations and advanced performance tuning?▼

SQL reference support spans from basic CRUD operations to advanced performance tuning. This skill facilitates comprehensive database development tasks, providing syntax and access patterns for relational database management across SQLite, PostgreSQL, and MySQL.

How do I generate a schema definition for a users table with unique constraints?▼

Generating a schema definition for a users table with unique constraints involves applying standard SQL syntax. This skill provides quick start patterns to implement tables including timestamps and unique constraints for robust relational database management.

Related Skills

Explore More Software Engineering Skills→
Interstellar-codeInterstellar-code
17

sql-cli

Execute SQL queries against MySQL and PostgreSQL databases from the command line.

Community
Advanced
AarononthewebAaronontheweb
1.1k

database-performance

Optimize .NET data access with EF Core and Dapper patterns.

Community
Advanced
yasarremreyasarremre

backend-engineer

Automate backend API, database, and server-side logic design.

Community
Advanced
Fancu1Fancu1

database-design

Design and optimize relational and NoSQL database schemas with migration patterns.

Community
Intermediate