Скачать или смотреть AI Dev Tip 2 - SQL Database Schema Walkthrough & Convert to Markdown, HTML, YAML, JSON w/ChatGPT

Today we’ll be looking at using to ChatGPT 4 AI to do a SQL Database Schema Walkthrough & Format Conversion Convert to Markdown, HTML, YAML, JSON in minutes!

📝 What You'll Learn:

Reasons for Using ChatGPT to Walk Through Database Schema

Simplified Explanation
Break down complex schema structures into simpler, understandable terms, making it easier for non-technical stakeholders to comprehend the architecture.

Interactive Learning
Users can ask questions in real-time, facilitating a more interactive and tailored learning experience.

Contextual Understanding
ChatGPT can provide contextual explanations and examples for specific tables, relationships, or fields, adding depth to the user's understanding.

Convert Schema to MARKDOWN
Convert Schema to HTML
Convert Schema to JSON
Convert Schema to YAML

Can you please take this schema I'm providing here and turn it into a markdown table so that I may share it with my team in documentation.

Can you please convert the same schema to HTML, so I can use it in an html document?

1. Make prompt input shorter by dividing into chunks.
Several times the prompt was getting too long for the AI and it barely pulled through.

2. Explicitly tell the AI not to truncate the output.
If it’s not sure it can pull of the output, it may just leave data out!

3. This is for prototyping, enterprise architecture requires fine-tuning
This is more like a sketch than a finished product. It requires fine-tuning and customizing to your use case.

4. Just about any widely used document type can be converted!
Keep asking for more document types as needed.

5. Remember that it can be inaccurate or leave out data.
Look it over carefully and make sure it did not remove or ignore data. It’s still experimental.

🛠️ Tools & Technologies:
ChatGPT-4: The AI powerhouse by OpenAI.
PostgreSQL: The world's most advanced open-source relational database.

PG SQL: https://www.pg-sql.com
ChatGPT: https://chat.openai.com/


Music credits:
"Hinkik - Skystrike [Electro House] Attribution 3.0 Unported (CC BY 3.0)
/ hinkik
Music provided by BreakingCopyright: https://bit.ly/skystrike-song

Upbeat Indie Corporate by Infraction [No Copyright Music] / Exhale
""Upbeat Indie Corporate" is 100% no copyright royalty free... Infraction is one of the safest YouTube channels dedicated to no copyright music for content creators. Can I use this track for my youtube video? Yes. You can use this track for any video (not only YouTube). "

Image credits:

Background image: @jipy32 https://unsplash.com/photos/75xPHEQBmvA