skills.rest
jxxghp
jxxghpCOMMUNITY
Explore all skills by this author →
GitHub

database-operation

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
One-click install
npx skills add https://github.com/jxxghp/MoviePilot --skill database-operation-jxxghp
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
leonj1leonj1

rds-postgres

Connect to Amazon RDS PostgreSQL databases and execute SQL queries.

Community
Intermediate
kivo360kivo360
1

moai-session-info-extended

Retrieve Git status, SPEC progress, version information, and system resources into a formatted status report.

Community
Advanced
iankikuiankiku
18

data

Design analytics systems, generate SQL queries, plan event tracking, and build dashboards.

Community
Advanced
fgarofalo56fgarofalo56
6

mssql-mcp

Execute SQL Server queries and manage schemas via natural language.

Community
Advanced