Database Query (数据库查询)

This skill guides you through executing SQL against the MoviePilot database. Both read and write operations are supported.

Prerequisites

You need the following tools:

• execute_command - Execute shell commands to run database queries

Getting Database Connection Info

The system prompt <system_info> section already contains all the database connection details you need:

• 数据库类型 — sqlite or postgresql
• 数据库 — Full connection info:
  • For SQLite: the database file path, e.g. SQLite (/config/db/moviepilot.db)
  • For PostgreSQL: the connection string, e.g. PostgreSQL (user:password@host:port/database)

Do NOT run any detection commands. Extract the database type and connection details directly from <system_info>.