A comprehensive command-line resource for designing, querying, migrating, and optimizing SQLite, PostgreSQL, and MySQL databases without ORM overhead.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install sql-toolkit
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install sql-toolkit using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is SQL Toolkit?
The SQL Toolkit is a robust framework designed for developers who need direct, high-performance interaction with relational databases. By focusing on raw SQL and CLI-native tools like psql, mysql, and sqlite3, it provides the patterns necessary for complex schema design, advanced query authorship, and database maintenance. This skill is a core part of the Openclaw Skills library, enabling seamless database operations across Linux, macOS, and Windows environments.
Whether you are performing quick data exploration with a zero-setup SQLite instance or managing a production PostgreSQL cluster with JSONB indexing and recursive CTEs, the SQL Toolkit ensures your workflows are efficient and scalable. It eliminates the abstraction layers of ORMs, giving you full control over performance optimization through EXPLAIN analysis and strategic indexing.
SQL Toolkit Use Cases
- Rapidly prototyping and storing local data using zero-configuration SQLite databases.
- Designing high-availability PostgreSQL schemas using UUIDs, TIMESTAMPTZ, and custom triggers.
- Writing complex analytical queries involving window functions, aggregations, and multi-step CTEs.
- Implementing automated, version-controlled database migrations for team-based development.
- Debugging performance bottlenecks by analyzing execution plans and implementing covering indexes.
- Orchestrating database backups and cross-platform data restores using standard CLI utilities.
How SQL Toolkit Works
- Initialize or connect to a database engine using the appropriate CLI binary (sqlite3, psql, or mysql).
- Define the relational structure using SQL DDL commands, incorporating constraints and foreign key relationships.
- Execute data manipulation or retrieval queries, utilizing advanced patterns like joins and subqueries for complex logic.
- Optimize query performance by reviewing EXPLAIN plans and applying index strategies to eliminate sequential scans.
- Manage long-term database health through structured migration scripts and regular backup routines.
SQL Toolkit Setup
To use the SQL Toolkit, ensure the relevant database client binaries are installed on your system. This skill supports Openclaw Skills environments on Linux, macOS, and Windows.
# Check for installed database clients
sqlite3 --version
psql --version
mysql --version
# To start a local SQLite database session
sqlite3 project_data.sqlite
# To connect to a remote PostgreSQL instance
psql "postgresql://user:password@localhost:5432/dbname"
SQL Toolkit Data Schema & Taxonomy
The SQL Toolkit uses a structured approach to manage database assets and metadata. It typically organizes data as follows:
| Component | Description |
|---|---|
| Schema Files | .sql files containing TABLE, INDEX, and TRIGGER definitions. |
| Migration Scripts | Numbered SQL files (e.g., 001_init.sql) tracked via a schema_migrations table. |
| Export Formats | Support for CSV, JSON, and raw SQL dump formats for data portability. |
| Metadata | PostgreSQL JSONB columns allow for semi-structured metadata storage within relational tables. |
| Configuration | Environment variables or connection strings used to authenticate CLI sessions. |
SQL Toolkit Advanced Features
- Advanced PostgreSQL integration including GIN indexes for JSONB and custom PL/pgSQL triggers for automated timestamp updates.
- Complex query patterns utilizing Recursive CTEs for hierarchical data traversal and Window Functions for time-series analysis.
- Strategic indexing capabilities including Partial Indexes for filtered datasets and Covering Indexes to minimize table lookups.
- High-concurrency SQLite performance tuning using Write-Ahead Logging (WAL) mode.
- Automated migration script patterns that ensure idempotent database updates across different environments.
- Expert-level performance auditing using EXPLAIN ANALYZE to identify high-cost database operations.
SKILL.md
Loading
Related Openclaw Skills
Skill Writer
A comprehensive framework for writing and publishing standardized Markdown-based skills that AI coding agents use to execute tasks and follow technical instructions.
Skill Search Optimizer
A technical guide and toolset for optimizing agent skill discoverability through semantic search alignment and description engineering.
Skill Reviewer
A comprehensive auditing framework and scoring system for evaluating the quality, structure, and actionability of AI agent skill files.
Shell Scripting
A professional toolkit for building reliable, portable, and production-ready Bash and POSIX shell scripts.
SSH Tunneling & Secure Remote Access
A comprehensive guide and toolset for managing SSH tunnels, secure port forwarding, and bastion host configurations.
Test Patterns
A comprehensive testing toolkit for writing, running, and debugging tests across Node.js, Python, Go, Rust, and Bash environments.
Featured*
