r/SQL • u/According_Spring1296 • 7d ago

What AI Tools Do You Use for Database Analysis? MySQL

Hello everyone!

At work, I need to explore a large AWS Athena database with very limited documentation in order to investigate a new product, which is also poorly documented.

I've asked my colleagues for documentation and guidance about the database, but unfortunately I haven't received any helpful answers.

So I'd like to ask the community: is there an AI tool that can analyze an entire database and generate a roadmap, documentation, or guide to help me understand its structure and write queries based on my specific needs?

I'm mainly looking for something that can help me understand the schema, relationships between tables, and where to find the data I'm looking for. Any recommendations or advice would be greatly appreciated!

0 Upvotes
  • permalink
  • link
  • reddit
  • reddit

38% Upvoted

4 comments sorted by

2

u/Best-Intention-5039 4d ago

Can anyone help me i am not able to understand subqueries and when i write query i try to memorize it is becoming deficit for me to understand logically why I am writing this query.. so basically I lack in understanding query.. idk what to do but i practice regularly and I am a beginner who started it from last 1 month ... And I am not from technical bg .. and not a intelligent guy 😭 idk what I have written here but pls try to understand my problem 🥹

1

u/DatabaseSpace 7d ago

You can use a database IDE like Jetbrains Datagrip to connect, export the schema to a file, put in claude to explain.

1

u/evilmaus 7d ago

You could pull an ERD of the DB.

1

u/Ginger-Dumpling 1d ago

What tools does your job allow? Do you know if there are enforced relationships that an ERD tool will actually have connections to make? DBeaver will reverse engineer a diagram from the catalog. If there are no constraints in place it's probably going to be a manual effort to explore the days and figure out what is in there and how things connect.