mail.app – Authorisation Denied Accessing macOS ~/Library/Mail/V10/MailData/Envelope Index

I am making an attempt to put in writing an AI agent to talk with my mail. Step one is entry to the mail objects themselves.

AppleScript was too sluggish, so I am making an attempt to make use of Python and Sqlite with the code under

import os
import sqlite3
# Perform to connect with the Mail app's SQLite database
def connect_to_mail_db():
    mail_db_path = os.path.expanduser('~/Library/Mail/V10/MailData/Envelope Index')
    conn = sqlite3.join(mail_db_path)
    return conn
# Perform to fetch email particulars
def fetch_email_details(conn):
    return
# Essential script
if __name__ == "__main__":
    # Connect with the Mail app's database
    conn = connect_to_mail_db()
    # Shut the database connection
    conn.shut()

Nonetheless that is giving an authorisation error.

~/PythonProjects/email_rag ❯ /Customers/<me>/.pyenv/variations/3.13.1/envs/email_rag/bin/python /Customers/<me>/PythonProjects/email_rag/export_email_via_sql.py                email_rag 3.13.1  system
Traceback (most up-to-date name final):
  File "/Customers/<me>/PythonProjects/email_rag/export_email_via_sql.py", line 14, in <module>
    conn = connect_to_mail_db()
  File "/Customers/<me>/PythonProjects/email_rag/export_email_via_sql.py", line 6, in connect_to_mail_db
    conn = sqlite3.join(mail_db_path)
sqlite3.DatabaseError: authorization denied

I can entry the database in terminal with
$ sqlite3 Envelope Index and I can entry the database with Native Sqlite Supervisor

I suspected SIP, however the truth that Native can entry the DB would counsel in any other case.

Anybody utilizing code to entry the Apple mail.app database?