skills.rest
aashari
aashariCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

mail-accounts

Enumerate Apple Mail synced accounts with email addresses, message counts, and mailbox structure.

5|Updated Feb 28, 2026
Search Tags:#sqlite#macos#apple-mail#mail-accounts#maildata#account-stats
One-click install
npx skills add https://github.com/aashari/ai-agent-skills --skill mail-accounts
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: mail-accounts
Source: https://github.com/aashari/ai-agent-skills/tree/main/skills/apple-mail/mail-accounts
Command: npx skills add https://github.com/aashari/ai-agent-skills --skill mail-accounts

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires sqlite3.

What problem does it solve?

Identify and enumerate all Apple Mail synced accounts, exposing each account's email identity, total message count, unread count, and the mailbox structure to give a clear overview of your Mail.app setup.

Core Features & Use Cases

  • Enumerates all local Apple Mail accounts by inspecting the Envelope Index data.
  • Returns per-account details: email address, account type, total messages, unread messages, and folders.
  • Use cases include auditing mail configurations, verifying account coverage, and preparing reports for support or migration.

Quick Start

List all Apple Mail synced accounts with their email addresses, total message counts, unread counts, and mailbox structure.

Frequently Asked Questions about mail-accounts

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

FAQPage Schema
How do I list all Apple Mail accounts and their email addresses on macOS?▼

You can list Apple Mail accounts by querying the Envelope Index data located in ~/Library/Mail. This enumerates all synced accounts, exposing each email address, account type, and mailbox structure.

How do I get total message counts and unread counts for my Apple Mail accounts?▼

You can get total and unread message counts for Apple Mail accounts by querying the Maildata sqlite database. This surfaces per-account volume metrics, including total messages and unread messages, for your Mail.app setup.

Can I check my Apple Mail account configuration and mailbox structure using sqlite3?▼

Yes, you can check your Apple Mail account configuration by using the sqlite3 binary to query local Maildata. This approach reveals the synced accounts, their email identities, and the complete mailbox structure.

Does this method for auditing Apple Mail accounts require local access on macOS?▼

Yes, auditing Apple Mail accounts this way requires local access to the Mail.app data in ~/Library/Mail on macOS. It also requires the sqlite3 binary to query the envelopes and mailboxes.

What is the best way to prepare an Apple Mail migration report with account stats?▼

The best way to prepare an Apple Mail migration report is to extract account stats from the local Maildata. This provides per-account details like email addresses, total messages, unread counts, and mailbox folders for support reporting.

Related Skills

Explore More Data & Analytics Skills→
aashariaashari
5

mail-top-senders

Query local mailbox data with sqlite3 to rank top senders and analyze communication patterns.

Community
Intermediate
aashariaashari
5

mail-core

Document Apple Mail local storage layout and EMLX parsing techniques.

Community
Advanced
JeffallanJeffallan
10.9k

database-optimizer

Diagnose slow queries and optimize indexes for PostgreSQL and MySQL.

Community
Advanced
cxnaivecxnaive

himalaya

Manage IMAP and SMTP email accounts from the terminal via himalaya CLI.

Community
Intermediate