Projects using Prisma in KarachiProjects using Prisma in KarachiAutoRank — AI SEO & Conversion App for Shopify
Role: Full-stack developer (design + frontend + backend)
Type: Embedded Shopify app (public app)
Overview
AutoRank is an AI-powered SEO and conversion-optimization app for Shopify merchants. It automates a store's entire organic-growth workflow — writing and publishing SEO blog content, optimizing on-page metadata, auditing technical SEO, and diagnosing conversion drop-offs — all from inside the Shopify admin. It uses a bring-your-own-key (BYOK) model, so merchants connect their own AI provider (OpenAI, Claude, Gemini, or Groq) and the app orchestrates everything around it.
What it does
AI blog automation — writes full SEO articles in the store's brand voice on a schedule (daily/weekly), with auto-publishing, AI/stock featured images, JSON-LD structured data, and a topic queue.
SEO optimizer — bulk-generates product-accurate meta titles and descriptions for products and pages, with per-item SEO scoring.
Image optimizer — real image compression (before/after byte savings) plus AI-generated alt text.
Site audit — sitemap-driven technical SEO crawl, broken-link detection with one-click 301 redirects, and Core Web Vitals (PageSpeed).
CRO deep scan — renders the live storefront in a real headless browser, captures desktop/mobile screenshots, diagnoses the conversion funnel (where shoppers drop off) using Shopify analytics, and runs a vision-based AI audit that returns exact fixes. Includes a consent-aware behavioral click heatmap.
Features control center — one-click toggles that do real work: auto-publishing HTML sitemaps, JSON-LD rich-result schema, and set-and-forget AI automations.
Google Search Console integration for live search-performance data.
Tech stack
React Router v7 · TypeScript · Shopify Polaris & App Bridge · Node.js · Prisma · PostgreSQL (Neon) · BullMQ · Shopify Admin GraphQL API · Theme app extensions & app proxy · Puppeteer/Chromium · Fly.io (http://Fly.io) · AES-256-GCM encryption
Highlights
Built a Polaris-native design system with a clear "green = action, purple = AI" visual language and reusable components.
Real browser-rendered CRO analysis (screenshots + funnel + heatmap), not just static checks.
Secure BYOK architecture with encrypted credentials and multi-provider AI abstraction.
Consumption-based billing with a 7-day trial and three subscription tiers.
App URL: https://apps.shopify.com/autorank-seo-blog-cro EstateFlow is a full-stack real estate platform built with Next.js, Prisma ORM, and PostgreSQL. Designed for seamless property discovery across major cities in Pakistan, it features custom location filtering, automated email workflows for user leads and inquiry management, and an intuitive UI focused on performance.
Full-stack real estate management web application engineered for browsing verified property listings with fast search, automated workflows, and dynamic filtering.
Frontend: Next.js & Tailwind CSS for modern, responsive UI design
Backend & Database: Prisma ORM with relational database schema for optimized routing and data management
Automation: Integrated email notification pipelines for real-time buyer inquiries and updates
Features: Multi-city listings search, dynamic property cards, theme switching, and automated lead handling 
