Backend Queries

🌐Community
by florianriquelme · vlatest · Repository

Executes complex database queries against florianriquelme's backend systems to retrieve specific data and insights.

Install on your platform

We auto-selected Claude Code based on this skill’s supported platforms.

1

Run in terminal (recommended)

terminal
claude mcp add florianriquelme-backend-queries npx -- -y @trustedskills/florianriquelme-backend-queries
2

Or manually add to ~/.claude/settings.json

~/.claude/settings.json
{
  "mcpServers": {
    "florianriquelme-backend-queries": {
      "command": "npx",
      "args": [
        "-y",
        "@trustedskills/florianriquelme-backend-queries"
      ]
    }
  }
}

Requires Claude Code (claude CLI). Run claude --version to verify your install.

About This Skill

What it does

This skill allows AI agents to execute backend queries within a Statamic CMS environment. Specifically, it facilitates retrieving and manipulating data directly from the Statamic database. It's designed for advanced users needing programmatic access to their site’s content beyond what standard APIs provide.

When to use it

  • Automating repetitive tasks like generating reports or exporting large datasets.
  • Building custom admin panels or tools that require direct database interaction.
  • Integrating Statamic with external systems through complex data synchronization processes.
  • Performing advanced searches and filtering of content based on specific criteria not easily achievable via standard queries.

Key capabilities

  • Direct access to the Statamic CMS database.
  • Ability to execute custom SQL queries.
  • Data retrieval and manipulation within the Statamic environment.

Example prompts

  • "Retrieve all published blog posts with tags 'technology' and 'AI'."
  • "Generate a CSV export of all users registered in the last 30 days."
  • "Update the status of order #12345 to 'shipped'."

Tips & gotchas

This skill requires a strong understanding of SQL and the Statamic CMS database schema. Incorrectly formatted queries can potentially damage your data, so use with caution and test thoroughly in a development environment first.

Tags

🛡️

TrustedSkills Verification

Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.

Security Audits

Gen Agent Trust HubPass
SocketPass
SnykPass

Details

Version
vlatest
License
Author
florianriquelme
Installs
2

🌐 Community

Passed automated security scans.