Trello Database - Leaked, Download!
by emo - Tuesday July 16, 2024 at 12:07 AM
#31
Cool Cool Cool
#32
Just Check some data, Thanks for sharing this DB
#33
Legit data. Good work sharing this. Big heart to share
#34
thank you very much for the share!
#35
Thanks for the content rep
#36
Thanks for this useful peace of info.
#37
(07-16-2024, 12:07 AM)emo Wrote: . EMO.RIP 3XCL4S1V3 | #DyingSlowly .
..............................................
....................../\......................
.................=---/--\---=.................
..................`-/....\-'..................
....../\.........../.`,.'.\.........../\......
.=---/--\---=...../,-'..'-.\.....=---/--\---=.
..`-/....\-'......'........`......`-/....\-'..
.../.`,.'.\......................../.`,.'.\...
../,-'..'-.\....................../,-'..'-.\..
..'........`......................'........`..
..............................................

Trello had an open API endpoint that allows any unauthenticated user to map an email address to a trello account.
I originally was only going to feed the endpoint emails from 'com' (OGU, RF, Breached, etc.) databases but I just decided to keep going with emails until I was bored.
This database is very useful for doxing, find enclosed email address matched to full names and aliases matched to personal email addresses.

Unique Email Addresses: 15,111,945
Contains: Email addresses, Names, Usernames
Breach date: 16 January 2024


Download

Sample Spoiler



Thank you my friend
Ban reason: Leeching | http://raiddfzn73ir6iyxlf7nwytnujiflddog...an-Appeals if you feel this is incorrect. (Permanent)
#38
First difficulty is to see the password... mystery and no one says it... this is odd and strange at least. Can anyone inform here the password?
Also would be nice if a good Samaritan republished it in SQLite format, as CSV always a pain as this case shows...

(07-16-2024, 02:41 AM)fjfj3 Wrote: For anyone who has difficulty reading it because it's a 21GB file. Use this to convert it to a readable database, you can query it much faster.

if you want more than uid, email, user and name, then change table structure and just read the other keys from the entry and insert them. if u cant figure out ask someone
import json import sqlite3 from tqdm import tqdm conn = sqlite3.connect('trello.db') cursor = conn.cursor() cursor.execute('''     CREATE TABLE IF NOT EXISTS trello_users (         id TEXT PRIMARY KEY,         fullName TEXT,         username TEXT,         email TEXT     ) ''') conn.commit() conn.close() def parse(json_file):     conn = sqlite3.connect('trello.db')     cursor = conn.cursor()     with open(json_file, 'r') as f:         for line in f:             try:                 entry = json.loads(line.strip())                 id = entry.get('id', '')                 fullName = entry.get('fullName', '')                 username = entry.get('username', '')                 email = entry.get('email', '')                 cursor.execute('''                     INSERT OR IGNORE INTO trello_users (id, fullName, username, email)                     VALUES (?, ?, ?, ?)                 ''', (id, fullName, username, email))             except json.JSONDecodeError as e:                 print(f"Shit broke: {e}")                 continue     conn.commit()     conn.close() if __name__ == '__main__':     parse('trellfull.json')
#39
The download is only 481MB, and it is damaged.
#40
easy load into mongodb:

{"id": "4d5eb3cad76aa11360000110", "aaId": "70121:582fd5ad-a739-49e8-89c4-99e76fc5f514", "activityBlocked": false, "avatarHash": "2810c1f514b3406eeb5abf5e26b3bdb3", "avatarUrl": "https://trello-members.s3.amazonaws.com/4d5eb3cad76aa11360000110/2810c1f514b3406eeb5abf5e26b3bdb3", "bio": "", "bioData": {"emoji": {}}, "confirmed": true, "fullName": "Bobby Grace", "idEnterprise": null, "idEnterprisesDeactivated": null, "idMemberReferrer": null, "idPremOrgsAdmin": null, "initials": "BG", "memberType": "normal", "nonPublic": {}, "nonPublicAvailable": true, "products": [], "url": "https://trello.com/bobbygrace", "username": "bobbygrace", "status": "disconnected", "aaBlockSyncUntil": null, "aaEmail": null, "aaEnrolledDate": null, "avatarSource": null, "credentialsRemovedCount": null, "domainClaimed": null, "email": "johnrobertgracejr@gmail.com", "gravatarHash": null, "idBoards": ["52952087bfa6ee005f0016c9", "54971ad5c1b6f54d71813a15", "5530334a9fd952764e448eab"], "idOrganizations": [], "idEnterprisesAdmin": [], "limits": {"boards": {"totalPerMember": {"status": "ok", "disableAt": 4500, "warnAt": 3600}}, "orgs": {"totalPerMember": {"status": "ok", "disableAt": 850, "warnAt": 680}}}, "loginTypes": null, "marketingOptIn": null, "messagesDismissed": null, "nodeId": "ari:cloud:trello::user/4d5eb3cad76aa11360000110", "oneTimeMessagesDismissed": null, "sessionType": null, "prefs": null, "trophies": [], "uploadedAvatarHash": null, "uploadedAvatarUrl": null, "premiumFeatures": ["additionalBoardBackgrounds", "additionalStickers", "customBoardBackgrounds", "customEmoji", "customStickers", "plugins"], "isAaMastered": true, "ixUpdate": "487"}
{"id": "4d5eb4c7d76aa113600001ab", "aaId": "70121:6a128b1b-1f29-4148-b31b-8173e052cee5", "activityBlocked": false, "avatarHash": "352d0a1768a45b0109edf7460a688cf2", "avatarUrl": "https://trello-members.s3.amazonaws.com/4d5eb4c7d76aa113600001ab/352d0a1768a45b0109edf7460a688cf2", "bio": "", "bioData": {"emoji": {}}, "confirmed": true, "fullName": "Kevin Gessner", "idEnterprise": null, "idEnterprisesDeactivated": null, "idMemberReferrer": null, "idPremOrgsAdmin": null, "initials": "KG", "memberType": "normal", "nonPublic": {}, "nonPublicAvailable": true, "products": [], "url": "https://trello.com/kevin", "username": "kevin", "status": "disconnected", "aaBlockSyncUntil": null, "aaEmail": null, "aaEnrolledDate": null, "avatarSource": null, "credentialsRemovedCount": null, "domainClaimed": null, "email": "kevingessner@gmail.com", "gravatarHash": null, "idBoards": [], "idOrganizations": [], "idEnterprisesAdmin": [], "limits": {"boards": {"totalPerMember": {"status": "ok", "disableAt": 4500, "warnAt": 3600}}, "orgs": {"totalPerMember": {"status": "ok", "disableAt": 850, "warnAt": 680}}}, "loginTypes": null, "marketingOptIn": null, "messagesDismissed": null, "nodeId": "ari:cloud:trello::user/4d5eb4c7d76aa113600001ab", "oneTimeMessagesDismissed": null, "sessionType": null, "prefs": null, "trophies": [], "uploadedAvatarHash": null, "uploadedAvatarUrl": null, "premiumFeatures": ["additionalBoardBackgrounds", "additionalStickers", "customBoardBackgrounds", "customEmoji", "customStickers", "plugins"], "isAaMastered": true, "ixUpdate": "3283"}


Possibly Related Threads…
Thread Author Replies Views Last Post
  La Poste Mobile Database - Leaked, Download! Automation 69 15,457 10 hours ago
Last Post: venom1000
  China Mobile (中国移动) 2022 Database - Leaked, Download! DAN_8 35 921 Yesterday, 02:57 PM
Last Post: nigganigganigganigga
  Ledger Database - Leaked, Download! Automation 96 28,457 07-21-2026, 06:51 PM
Last Post: dyzet1337
  Duolingo Scrape Database - Leaked, Download! gl0rp 108 43,137 07-21-2026, 12:14 PM
Last Post: Yunu599
  Turknet Database - Leaked, Download! dejavu 82 2,956 07-21-2026, 12:04 PM
Last Post: Yunu599



 Users browsing this thread: 1 Guest(s)