Clause Code : DB Setup

-

https://neon.com/

  • Will be setting up postgres DB on neon
  • it gives upto 10 databases for free ( no need to add credit card )

drizzle ORM https://orm.drizzle.team/docs/get-started-postgresql

https://ui.shadcn.com/ it is a set of beautifully designed components that you can customize, extend, and build on.

if you want to install drizzle into your codebase using claude code all you do is type "install drizzle into the project using the following documentation <paste all data from link below>" https://orm.drizzle.team/docs/get-started-postgresql

Create DB Schema

  • switch claude code into plan mode (shift + tab) 
  • use prompt like "Plan a table schema to log workouts. Each workout can have multiple exercises, and each exercise can have multiple sets. make sure this is normalized. Then, because we're using drizzle for our project, ideally we will inform cloud code that we want to create a drizzle schema."

[prompt 1 / plan mode]:
this is a workout logging app. plan a table schema to log workouts, each workout can have multiple exercises, and each exercise can have multiple sets. make sure this is normalized. the schema must be created using drizzle orm for a postgres db hosted on neon.

[prompt 2 / plan mode]:
this plan looks good, it just needs a few tweaks. add a started_at and completed_at column for the workouts table. also remove the notes and duration.

[prompt 3 / plan mode]:
for the exercises table remove the description, muscle_groups, equipment_type, but add a created_at and updated_at olumn. for the workout_exercises table rename the oder_in_workout to order, remove the notes, and add a created_at column. for the sets table remove the rpe, rest_time and notes, but add a created_at column.

Use Neon MCP in claude code to generate schema db

[terminal]:
npx drizzle-kit push

[terminal]:
npx add-mcp https://mcp.neon.tech/mcp

[prompt 1 / default mode]:
/mcp

[prompt 2 / default mode]:
list all of the available tables within the liftingdiarycourse db on neon

[prompt 3 / default mode]:
generate some example data for the above tables for user id [enter_user_id_here]. do not insert any data just yet into the neon database. I want to check the example data first.

[prompt 4 / default mode]:
this looks great. now insert all of that example data to the liftingdiarycourse db




Comments

Post a Comment

Popular posts from this blog

Agentic AI Course : Week 1

-
Image
8 weeks https://edwarddonner.com/2024/11/13/llm-engineering-resources/  6 week Agentic AI Course https://github.com/ed-donner/agents the file .env has all the keys select kernel https://github.com/ed-donner/agents/blob/main/1_foundations/1_lab1.ipynb import os openai_api_key = os.getenv( 'OPENAI_API_KEY' ) from openai import OpenAI openai = OpenAI() messages = [{ "role" : "user" , "content" : "What is 2+2?" }] response = openai.chat.completions.create(      model= "gpt-4.1-nano" ,      messages=messages      ) print (response.choices[ 0 ].message.content) Day 2 : what are AI Agents? 5 different patterns for agentic systems https://lavnish.blogspot.com/2025/05/essential-design-patterns-for-building.html In General Day 3 comparing different models  https://www.vellum.ai/llm-leaderboard syntax to call diff LLMs openAI , anthropic, gemini, deepseek, groq https://github.com/ed-donner/agents/blob/main/1_foundations/2_lab2.ipynb...
Read more

LLM Engineering course : Day 1

-
Image
 Anaconda Power Shell    this will open , way you know if it is a anaconda power shell by seeing "base" Then you can install the full environment    then to activate use command "conda activate llms"     Open Ques "what is environment.yml" Then activate the conda environment and open jupyter lab   you can start with virtualenv as well (all details in readme) Video 11 : Day 1 every AI has 2 types of plan 1) pro plan with UI monthly subscription 2) API pricing , pay per request, for OPEN API need to put in 5$ pre payment (can use gpt4-o-mini for less cost)  (all details in readme)  Video 11:  store keys in .env files (all details in readme)  Video 14 there are two types of prompt   Video 15 OpenAI came up with a standard way of interacting with LLMs which is now standard for many LLMs. It is a list of dictionaries. Use completions API https://platform.openai.com/docs/guides/completions   For websites that use Java...
Read more

LLM Engineering : Week 2

-
Day 2.1 setup  anthropic api key google api key (more complex) update .env file     What is Temperature ?  Pass value between 0 to 1. 1 is most creative , 0 is least There is a slight difference in Claude API and OpenAI  in claude API we pass system message and user message separately in claude we also give context  if you want to stream , in claude there is an extra method , in openAI there is a boolean attribute.    Day 2.2 : Gradio         Day 2.3         Day 2.4 Day 2.5          
Read more