SkillData & analytics
pg_dump Reference
Consult PostgreSQL's pg_dump implementation for guidance on system catalog queries and schema extraction when implementing pgschema features
◈OpenClaw
MIT · FreeView skill
FREE RESOURCE LIBRARYAI prompts and
AI prompts and
agent skills.
Browse reusable instructions for your AI tools. Copy and customize a prompt, or download a skill for a supported agent.
108 prompts7560 skills6 platforms
Browse resources 
FILTER BY AI TOOLAll platforms 7668
BROWSE RESOURCES
OpenClaw resources5071 resources
SkillData & analytics
PostgreSQL Migrations Skill
Comprehensive guide to PostgreSQL migrations - common errors, generated columns, full-text search, indexes, idempotent migrations, and best practices for database schema changes
◈OpenClaw
MIT · FreeView skill
SkillData & analytics
PostgreSQL Syntax Reference
Consult PostgreSQL's parser and grammar (gram.y) to understand SQL syntax, DDL statement structure, and parsing rules when implementing pgschema features
◈OpenClaw
MIT · FreeView skill
SkillData & analytics
Validate with Database
Connect to live PostgreSQL database to validate schema assumptions, compare pg_dump vs pgschema output, and query system catalogs interactively
◈OpenClaw
MIT · FreeView skill
SkillData & analytics
Wheels Migration Generator
Generate database-agnostic Wheels migrations for creating tables, altering schemas, and managing database changes. Use when creating or modifying database schema, adding tables, columns, indexes, or foreign keys. Prevents database-specific SQL and ensures cross-database compatibility.
◈OpenClaw
MIT · FreeView skill
SkillData & analytics
SQL Expert
Write, optimize, and debug T-SQL queries for Microsoft SQL Server. Covers CTEs, window functions, PIVOT, MERGE, APPLY operators, execution plan analysis, indexing strategies, and stored procedures. Use when working with SQL Server, T-SQL scripts, .sql files, stored procedures, query optimization,...
◈OpenClaw
MIT · FreeView skill
SkillData & analytics
OceanBase SQL Optimization Skill
SQL optimization best practices for OceanBase database (MySQL & Oracle modes). Covers query optimization, index usage, execution plan analysis, slow query tuning, and performance optimization techniques. Activates for SQL optimization, query performance, index design, execution plan, slow query, ...
◈OpenClaw
MIT · FreeView skill
SkillData & analytics
relational-database-mcp-cloudbase
This is the required documentation for agents operating on the CloudBase Relational Database. It lists the only four supported tools for running SQL and managing security rules. Read the full content to understand why you must NOT use standard Application SDKs and how to safely execute INSERT, UP...
◈OpenClaw
MIT · FreeView skill
SkillData & analytics
TimescaleDB Complete Setup
Step-by-step instructions for designing table schemas and setting up TimescaleDB with hypertables, indexes, compression, retention policies, and continuous aggregates. Instructions for selecting: partition columns, segment_by columns, order_by columns, chunk time interval, real-time aggregation.
◈OpenClaw
MIT · FreeView skill
SkillData & analytics
Database Backup & Restore
Implement backup and restore strategies for disaster recovery. Use when creating backup plans, testing restore procedures, or setting up automated backups.
◈OpenClaw
MIT · FreeView skill
SkillData & analytics
Stored Procedures & Functions
Implement stored procedures and functions for database logic. Use when creating reusable database routines, complex queries, or server-side calculations.
◈OpenClaw
MIT · FreeView skill
SkillData & analytics
Transaction Management
Manage database transactions for data consistency. Use when implementing ACID compliance, handling concurrency, or managing transaction isolation levels.
◈OpenClaw
MIT · FreeView skill
SkillData & analytics
Database Migrations Core Knowledge
Database migration strategies and best practices. Covers schema versioning, zero-downtime migrations, rollback patterns, and data migration techniques. Use for database evolution and deployment planning. USE WHEN: user mentions "database migrations", "schema changes", "versioning", "rollback", "...
◈OpenClaw
MIT · FreeView skill
SkillData & analytics
SQL Server - Quick Reference
SQL Server and Azure SQL Database with T-SQL, indexes, stored procedures, and performance optimization patterns. USE WHEN: user mentions "SQL Server", "T-SQL", "MSSQL", "Azure SQL", "SQL Server indexes", "stored procedures", "SQL Server performance" DO NOT USE FOR: PostgreSQL - use `postgresql`...
◈OpenClaw
MIT · FreeView skill
SkillData & analytics
PostgreSQL Deep Dive
PostgreSQL deep-dive: EXPLAIN ANALYZE interpretation, index types (B-tree, GIN, GiST, BRIN), partial/covering/composite indexes, pg_stat_statements slow query analysis, Row Level Security, window functions, CTEs, advisory locks, LISTEN/NOTIFY, connection pooling with PgBouncer. Use when optimizin...
◈OpenClaw
MIT · FreeView skill
SkillData & analytics
Database Conventions
Apply when writing or modifying database schema, queries, or migrations.
◈OpenClaw
Apache-2.0 · FreeView skill
SkillData & analytics
PostgreSQL MCP Skill
Official PostgreSQL Model Context Protocol Server for database interaction.
◈OpenClaw
MIT · FreeView skill
SkillData & analytics
database-optimization-duc01226-easyplatform
Use when optimizing database queries, indexes, N+1 problems, slow queries, or analyzing query performance. Triggers on keywords like "slow query", "N+1", "index", "query optimization", "database performance", "eager loading".
◈OpenClaw
MIT · FreeView skill
SkillData & analytics
cross-env-postgresql-extensions
Activate when creating database migrations that enable or disable PostgreSQL extensions. Provides the DO block pattern for cross-environment compatibility between Nhost Cloud, CNPG (CloudNativePG), and other PostgreSQL environments.
◈OpenClaw
MIT · FreeView skill
SkillData & analytics
drizzle-migrations
Manage database schema with Drizzle ORM and SQLite migrations. Use when adding tables, modifying columns, creating indexes, or running migrations. Activates for database schema changes, migration generation, and Drizzle query patterns.
◈OpenClaw
MIT · FreeView skill
SkillData & analytics
clickhouse-pydantic-config
Generate DBeaver configurations from Pydantic ClickHouse connection models. Use when user mentions "DBeaver config", "ClickHouse connection setup", "database client configuration", "generate connection JSON", "mise SSoT connection", or needs consistent connection configuration across development ...
◈OpenClaw
MIT · FreeView skill
SkillData & analytics
clickhouse-architect
ClickHouse schema design and optimization. TRIGGERS - ClickHouse schema, compression codecs, MergeTree, ORDER BY tuning, partition key.
◈OpenClaw
MIT · FreeView skill
SkillData & analytics
db-performance-patterns
Patterns for optimizing database queries and preventing connection pool exhaustion. Use when writing batch operations, debugging slow queries, or reviewing code for performance.
◈OpenClaw
MIT · FreeView skill
SkillData & analytics
db-schema-change
Handle Drizzle database schema changes safely. Generate and apply migrations, add tables and columns. Use when modifying database schema, adding tables, creating migrations, or making database changes.
◈OpenClaw
MIT · FreeView skill
No matching resources.
Try another platform, a broader search, or fewer filters.
Explore all resourcesResource formats: Prompts are ready to copy into a conversation. Skills install into the compatible agent shown on their page.
How it worksCONTRIBUTE
Submit a resourceSubmit a prompt or skill
Include the instructions, intended platforms, author, and license. Submissions are reviewed before publication.