Function getAccountHandler

server/src/addie/mcp/admin-tools.ts:1992–2415

(input: Record<string, unknown>)

  // Shared handler for get_account and get_organization_details
  const getAccountHandler = async (input: Record<string, unknown>) => {

    const pool = getPool();
    const query = input.query as string;
    // Escape LIKE wildcards in the user-supplied query so a literal `%` or `_`
    // doesn't fan out to every org or signup. Equality comparison ($2) doesn't
    // need it; prefix and substring comparisons do.
    const escapedQuery = query.replace(/[\\%_]/g, '\\$&');
    const searchPattern = `%${escapedQuery}%`;

    try {
      // Find organizations by name or domain - get up to 5 matches
      const result = await pool.query(
        `SELECT o.*,
                p.name as parent_name
         FROM organizations o
         LEFT JOIN brands db_parent ON o.email_domain = db_parent.domain
         LEFT JOIN organizations p ON db_parent.house_domain = p.email_domain
         WHERE o.is_personal = false
           AND (LOWER(o.name) LIKE LOWER($1) ESCAPE '\\' OR LOWER(o.email_domain) LIKE LOWER($1) ESCAPE '\\')
         ORDER BY
           CASE WHEN LOWER(o.name) = LOWER($2) THEN 0
                WHEN LOWER(o.name) LIKE LOWER($3) ESCAPE '\\' THEN 1
                ELSE 2 END,
           o.updated_at DESC
         LIMIT 5`,
        [searchPattern, query, `${escapedQuery}%`]
      );

      if (result.rows.length === 0) {
        // Fall back to the users table — inbound website signups don't create
        // an org row (the user self-serves during onboarding), so the only
        // record of "someone from this company signed up" lives in `users`.
        // Domain anchor: pattern is `%@<query>%` so "diageo" matches @diageo.com
        // and @diageo.co.uk but NOT @nondiageo.com — query must immediately
        // follow `@`. `escapedQuery` (declared above) neutralizes LIKE
        // wildcards so a literal `%` doesn't fan out to every signup.
        const usersResult = await pool.query(
          `SELECT u.workos_user_id, u.email, u.first_name, u.last_name,
                  u.created_at, u.primary_organization_id, o.name AS primary_org_name
           FROM users u
           LEFT JOIN organizations o ON o.workos_organization_id = u.primary_organization_id
           WHERE LOWER(u.email) LIKE LOWER($1) ESCAPE '\\'
           ORDER BY u.created_at DESC
           LIMIT 10`,
          [`%@${escapedQuery}%`]
        );

        if (usersResult.rows.length === 0) {
          return `No organization found matching "${query}". Try searching by company name or domain.`;
        }

        const orphans = usersResult.rows.filter(u => !u.primary_organization_id);
        const linked = usersResult.rows.filter(u => u.primary_organization_id);

        let response = `No organization found matching "${query}", but ${usersResult.rows.length} user${usersResult.rows.length === 1 ? '' : 's'} signed up with a matching email domain.\n\n`;

        if (orphans.length > 0) {