Use this checklist to track your setup progress!
- Visited https://supabase.com
- Created free account
- Verified email address
- Logged into dashboard
- Clicked "New Project"
- Named project:
ai-portfolio(or your choice) - Set strong database password
- Saved password securely
- Selected closest region
- Waited for project setup (2-3 min)
- Confirmed project is active (green status)
- Opened Supabase dashboard
- Navigated to "SQL Editor" (left sidebar)
- Clicked "New query"
- Opened
supabase-setup.sqlfile - Copied ALL SQL content
- Pasted into SQL Editor
- Clicked "Run" button
- Saw success messages β
- Confirmed no error messages
- Opened "Table Editor" (left sidebar)
- Saw
visitor_sessionstable - Saw
page_viewstable - Saw
chat_messagestable - Saw
contact_submissionstable - Saw
user_interactionstable
- Opened "SQL Editor"
- Ran:
SELECT * FROM daily_visitors; - Ran:
SELECT * FROM popular_questions; - Ran:
SELECT * FROM contact_summary; - All views working β
- Went to Settings β API
- Located "Project URL"
- Copied Project URL
- Located "anon/public" key (NOT service_role!)
- Copied anon key
- Saved both in secure location
- Opened
config.jsin code editor - Replaced
YOUR_SUPABASE_URLwith actual URL - Replaced
YOUR_SUPABASE_ANON_KEYwith actual key - Removed any extra spaces
- Saved file
- Double-checked no typos
- Opened
index.htmlin browser - Pressed F12 to open console
- Saw "β Supabase connected successfully" message
- No error messages in console
- Chat interface loaded properly
- Typed a message in chat
- Pressed Enter or clicked send
- Saw typing indicator
- Received AI response
- Tried multiple questions
- Clicked "About Deepak" button
- AI responded correctly
- Clicked "Skills" button
- AI responded correctly
- Clicked "Projects" button
- AI responded correctly
- Clicked theme toggle button
- Theme changed to light/dark
- Clicked again
- Theme switched back
- Theme preference saved
- Opened Supabase β Table Editor
- Checked
visitor_sessionstable - Saw new session record β
- Checked
chat_messagestable - Saw chat messages recorded β
- Checked
user_interactionstable - Saw interactions recorded β
- Opened
script.js - Updated
knowledgeBase.about.name - Updated
knowledgeBase.about.role - Updated
knowledgeBase.about.education - Updated
knowledgeBase.about.description - Updated skills array
- Updated projects array
- Updated contact info
- Saved changes
- Updated profile picture (
profile.jpg) - Checked
styles.csscolors - Changed colors if desired
- Tested on desktop
- Tested on mobile
- Tested responsiveness
- Updated GitHub link in
index.html - Updated LinkedIn link
- Updated Instagram link
- Verified all links work
- Opened on mobile device OR
- Used browser dev tools (F12 β Toggle device)
- Tested chat interface
- Tested navigation
- Tested theme toggle
- Tested suggestions buttons
- Everything works smoothly β
- Tested on Chrome
- Tested on Firefox
- Tested on Safari (if available)
- Tested on Edge
- All browsers work β
- Created GitHub repository
- Pushed code to GitHub
- Went to Settings β Pages
- Selected branch (main/master)
- Selected root folder
- Waited for deployment
- Visited live URL
- Site is live! π
- Logged into Netlify
- Dragged folder to deploy OR
- Connected GitHub repository
- Waited for build
- Visited live URL
- Site is live! π
- Logged into Vercel
- Imported GitHub repository
- Waited for deployment
- Visited live URL
- Site is live! π
- Tested live site
- Chat works on live site
- Database recording on live site
- All features working
- Shared link with friends
- Checked daily visitors view
- Checked popular questions
- Checked chat statistics
- Reviewed user interactions
- Review contact submissions
- Check popular questions
- Monitor visitor trends
- Export data if needed
- Newsletter subscription
- Project reactions
- Chat feedback
- Skills endorsement
- Testimonials
- Blog system
- Availability calendar
- Download tracking
See API_DOCUMENTATION.md for implementation details.
- Updated LinkedIn profile with link
- Updated Instagram bio
- Updated GitHub profile README
- Shared on Twitter/X
- Shared in relevant communities
- Added to resume
- Added to email signature
- Updated meta description
- Added keywords
- Submitted to Google Search Console
- Created sitemap (optional)
- Set up analytics (optional)
- Check Supabase storage usage
- Review analytics insights
- Update personal info if needed
- Add new projects
- Update skills
- Respond to contact forms
- Backup database (optional)
- Run cleanup:
SELECT cleanup_old_data(90);
You know you're done when:
- β Portfolio loads without errors
- β AI chatbot responds correctly
- β Console shows "Supabase connected"
- β Data appears in Supabase tables
- β Theme toggle works
- β Mobile responsive
- β Live on the internet
- β All your info is updated
- β Social links work
- β You're proud to share it! π
- Checked
config.jsfor typos - Verified URL is correct
- Verified anon key is correct
- No extra quotes or spaces
- File is saved
- Refreshed browser
- Checked browser console (F12)
- Looked for error messages
- Verified JavaScript loaded
- Checked internet connection
- Tried different browser
- Confirmed Supabase connected
- Checked RLS policies enabled
- Verified table names match
- Tried inserting manually in SQL Editor
- Checked browser console for errors
- Tested in Chrome DevTools
- Checked responsive CSS
- Verified viewport meta tag
- Tested on real device
- Read
SETUP_SUMMARY.md - Read
SUPABASE_SETUP.md - Skimmed
API_DOCUMENTATION.md - Read
README.md - Bookmarked for reference
After completing this, you'll know:
- β How to build AI chatbots
- β Supabase database setup
- β Frontend-backend integration
- β Row Level Security (RLS)
- β Analytics and tracking
- β Deployment workflows
- β Responsive web design
- Everything works perfectly
- You understand how it works
- You can customize it
- It's deployed and live
- You've shared it
- You're monitoring analytics
- You're proud of it!
Use this space for your own notes:
Supabase URL: ___________________________________
Deployment URL: ___________________________________
Last Updated: ___________________________________
Congratulations! π
Once all boxes are checked, you have a fully functional AI-powered portfolio with complete backend analytics!
Time to celebrate and share it with the world! π
Last Updated: January 25, 2026 Portfolio Version: 2.0