storage-optimizer

Storage Optimizer

⚠️ Connection Required: ALWAYS CHECK FIRST

Before doing ANYTHING else in this skill, call ping on the Immich MCP server.

• If ping succeeds → proceed with the skill normally.
• If ping fails or the MCP tools are not available → STOP. Do not continue. Tell the user:

❌ Immich is not connected. This plugin needs a running Immich MCP server to work.

Run /setup-immich-photo-manager to configure your Immich connection. You'll need:

1. Your Immich server URL (e.g., http://192.168.1.100:2283)
2. An Immich API key (how to create one)
3. The MCP server configured (see /setup-immich-photo-manager)

Nothing in this plugin will work until the connection is configured.

Do NOT skip this check. Do NOT try to run any other tool first. Always ping, always block if it fails.

Analyze storage usage in an Immich photo library, identify the biggest consumers, and recommend strategies to reclaim space without losing important content.

When to Use

• Disk space running low on the Immich server
• After bulk imports to assess storage impact
• Planning storage capacity (how long until disk is full?)
• Deciding whether to keep RAW files, original videos, etc.

Analysis Workflow

Step 1: Storage Overview

get_statistics gives the totals (photos, videos, storage used) in one call, with no database access. The query below is the optional fallback for the per-type averages and maximums Immich's API does not report; the plugin never provides database access, so it only applies to a user who already has psql on their own Immich.

-- Total storage by asset type
SELECT type,
  count(*) as files,
  pg_size_pretty(sum(("exifInfo"->>'fileSizeInByte')::bigint)) as total_size,
  pg_size_pretty(avg(("exifInfo"->>'fileSizeInByte')::bigint)) as avg_size,
  pg_size_pretty(max(("exifInfo"->>'fileSizeInByte')::bigint)) as max_size
FROM asset WHERE "deletedAt" IS NULL
GROUP BY type;

-- Trash storage (reclaimable immediately)
SELECT
  count(*) as trashed_files,
  pg_size_pretty(sum(("exifInfo"->>'fileSizeInByte')::bigint)) as trash_size
FROM asset WHERE "deletedAt" IS NOT NULL;