database-operation

Name: database-operation
Availability: InStock
Author: jxxghp

Execute SQL queries against MoviePilot SQLite or PostgreSQL databases.

11.5k|1.4k|Updated May 31, 2023

Search Tags:#database #postgresql #maintenance #sqlite #sql #query

Ready to run

npx skills add https://github.com/jxxghp/MoviePilot --skill database-operation-jxxghp

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-operation
Source: https://github.com/jxxghp/MoviePilot/tree/main/skills/database-operation
Command: npx skills add https://github.com/jxxghp/MoviePilot --skill database-operation-jxxghp

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill enables executing SQL queries against the MoviePilot database to retrieve statistics, inspect and modify records, and perform maintenance tasks across supported databases (SQLite or PostgreSQL).

Core Features & Use Cases

Execute read and write SQL against the MoviePilot database.
Retrieve analytics such as counts, aggregates, and record details; inspect or fix raw data; perform cleanup operations.
Support both SQLite and PostgreSQL modes, adapting connection details from system prompts.

Quick Start

Run a targeted SQL query against the configured database to return results immediately.

Frequently Asked Questions about database-operation

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

FAQPage Schema

How do I execute SQL queries against the MoviePilot database?▼

To execute SQL queries against the MoviePilot database, the skill identifies connection details from the system prompt and uses the execute_command tool to run read or write operations safely.

Can I run SQL maintenance tasks on both SQLite and PostgreSQL databases?▼

Yes, you can run SQL maintenance tasks on both SQLite and PostgreSQL databases, as the skill adapts connection details from the system prompt to support both modes.

Does running database queries expose my database credentials?▼

No, running database queries does not expose credentials because the skill securely extracts connection details internally and executes commands without exposing them.

What can I do with SQL data statistics retrieved from the MoviePilot database?▼

You can retrieve data statistics like counts and aggregates, inspect raw records, perform cleanup operations, and modify data directly within the MoviePilot database.

Are there safety rules for modifying records in the MoviePilot database?▼

Yes, modifying records in the MoviePilot database requires adhering to safety rules enforced by the skill while using the execute_command tool to prevent unsafe operations.