How to List All Motherduck Users via API Beyond Service Principal Accounts?

·May 01, 2026 04:36 PM·

Is there a way to list all Motherduck users using the API? I am only able to see /active_accounts which from my testing only displays service principal accounts. Below is my python code in case I am doing something wrong:

from dotenv import load_dotenv
import requests
import os
import pandas as pd

# --- Setup ----
load_dotenv()
TOKEN = os.getenv("MOTHERDUCK_TOKEN")
HEADERS = {
    "Authorization": f"Bearer {TOKEN}",
    "Accept": "application/json",
}
BASE_URL = "https://api.motherduck.com/v1"


# --- List all active accounts ----
def list_active_accounts():
    url = f"{BASE_URL}/active_accounts"
    response = requests.get(url, headers=HEADERS)
    response.raise_for_status()
    return response.json()

# Only lists service principal accounts
all_active_accounts = list_all_active_accounts()

3 comments

· Sorted by Oldest

Tseegi (.
·
(edited)·
Hello Ajjit N.! You're absolutely right about active accounts, it will only return usernames for accounts that are currently active. Listing all users is a feature request that we're actively tracking. In the meantime, you could use either one or combination of these options:
1.
If you’re an org admin on Business, you can infer users who have run recent queries by obtaining unique user names fromQUERY_HISTORYorRECENT_QUERIESviews:
SELECT DISTINCT user_name from MD_INFORMATION_SCHEMA.QUERY_HISTORY;
3.
GET /v1/active_accounts: returns usernames for accounts that are currently active - which you're already using (https://motherduck.com/docs/sql-reference/rest-api/ducklings-get-active-accounts/)
4.
View members and service accounts via MotherDuck UI: https://app.motherduck.com/settings/members
👍1

Ajjit N.

(edited)·

In case it's helpful to to others, this python script worked via solution 1):

from dotenv import load_dotenv
import requests
import os
import duckdb
import pandas as pd

# --- Setup ----
load_dotenv()
TOKEN = os.getenv("MOTHERDUCK_TOKEN")
HEADERS = {
    "Authorization": f"Bearer {TOKEN}",
    "Accept": "application/json",
}
BASE_URL = "https://api.motherduck.com/v1"
MD_CONN = duckdb.connect(f"md:?motherduck_token={TOKEN}")




# --- List all org users via query_history ----
def list_all_users():
    df = MD_CONN.sql("""
        SELECT DISTINCT user_name
        FROM md_information_schema.query_history
        ORDER BY user_name
    """).df()
    return df["user_name"].tolist()

Tseegi (.
·
·
Hello Ajjit N.! You can now programmatically get user/service account list from the API. Release notes here: Please let us know how it goes!
🙌1