SQL

Design schemas, write portable SQL, and coordinate migrations across PostgreSQL, MySQL, SQLite, and SQL Server.

Updated Apr 2, 2026
One-click install
npx skills add https://github.com/ViewWay/openclaw-skills --skill sql-viewway
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: SQL
Source: https://github.com/ViewWay/openclaw-skills/tree/main/sql
Command: npx skills add https://github.com/ViewWay/openclaw-skills --skill sql-viewway

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Relational databases across multiple engines can be hard to design, query efficiently, and migrate safely; this Skill consolidates best practices for relational database design, querying, and migrations to reduce boilerplate and mistakes.

Core Features & Use Cases

  • Schema design patterns and best practices across PostgreSQL, MySQL, SQLite, and SQL Server.
  • Portable SQL querying and patterns to ensure cross-engine compatibility.
  • Migration, backup, and recovery guidance including versioning, rollbacks, and monitoring.
  • Performance tuning tips, indexing strategies, and cross-engine portability insights.

Quick Start

Run a quick health check against your database to validate schemas, basic queries, and migration readiness.

Frequently Asked Questions about SQL

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

FAQPage Schema
How do I write portable SQL queries that work across PostgreSQL, MySQL, SQLite, and SQL Server?

Portable SQL queries require following cross-engine compatibility patterns to avoid dialect-specific syntax. This Skill provides querying guidelines and design patterns that ensure your SQL operates consistently across PostgreSQL, MySQL, SQLite, and SQL Server.

What are the best practices for coordinating database schema migrations across multiple database engines?

Database schema migrations across engines require strict versioning, rollback strategies, and monitoring. This Skill defines guidelines for coordinating migrations, ensuring safe schema changes across PostgreSQL, MySQL, SQLite, and SQL Server without boilerplate mistakes.

Does this SQL guidance cover backup and recovery procedures for different relational database engines?

Yes, this SQL guidance covers backup and recovery procedures for multiple relational database engines. It provides migration, backup, and recovery guidance including versioning and rollbacks specifically designed for PostgreSQL, MySQL, SQLite, and SQL Server.

How do I design a relational database schema that remains efficient across different SQL engines?

Designing an efficient relational database schema across SQL engines requires applying cross-engine design patterns. This Skill consolidates schema design best practices and patterns to ensure your database structure remains optimal across PostgreSQL, MySQL, SQLite, and SQL Server.

Can I run a health check to validate my database schema and migration readiness?

Yes, you can run a health check to validate your database schema, basic queries, and migration readiness. This Skill enables a quick start health check against your database to ensure schemas and migrations are correctly configured.