
Closed
Posted
Paid on delivery
I need a seasoned backend developer to architect and code the APIs that will drive an instant-response customer-support chat and text-messaging service. The data layer is fixed on MySQL, so you will design the schema, write migrations, and ensure every query scales cleanly under load. The chat must feel live—messages should travel round-trip in well under a second—so expect to work with websockets or a similarly performant real-time layer. All traffic, both REST and socket, has to be secured by robust user authentication; agents and customers must only access the conversations they own. File sharing and typing indicators are not in scope right now, but please structure the code so these features can slot in later without rewrites. Deliverables • REST and websocket endpoints for chat and outbound SMS • MySQL schema plus migration scripts • Token-based authentication middleware integrated across endpoints • Unit tests, load-test script, and simple health checks • Postman/Swagger documentation and a README covering local setup, environment variables, and deployment steps Acceptance criteria • Messages delivered to all participants in <200 ms in a 1 k-user load test • No unauthenticated request returns chat data • Code quality passes linting and test suite with 90 % coverage If you have a track record with real-time messaging, websockets ([login to view URL], SignalR, native WS), and secure API design, I’m ready to see your approach and timeline.
Project ID: 40747807
117 proposals
Remote project
Active 2 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
117 freelancers are bidding on average $447 USD for this job

A support chat is trusted when two things are always true: a customer can never read another customer's conversation, and a message never gets lost or doubled when the connection drops. Your acceptance criteria point at exactly these, so I would design the API around them and prove them with tests. How I would build it: 1. Days 1-3: MySQL schema and migrations for users, conversations, participants and messages, with indexes for the history queries, and token authentication middleware shared by the REST and socket layers. 2. Days 4-7: REST endpoints for conversations and message history (paged by message ID, not by offset), and WebSocket channels in Node.js with TypeScript: every room join and every query checks that the user belongs to the conversation, so guessing an ID returns nothing. A client-generated message ID prevents duplicate sends on retry. 3. Days 8-10: outbound SMS through a provider API with delivery status callbacks and a queue for retries; Redis pub/sub so a message reaches participants connected to any server instance. 4. Days 11-12: load-test script for 1,000 users with latency measured per delivery against your 200 ms target, health checks, rate limiting. 5. Days 13-14: unit and integration tests with coverage above 90%, lint passing, Swagger or Postman documentation, and a README with local setup, environment variables and deployment steps. File sharing and typing indicators are left as clean extension points. My rating on Freelancer is 4.98 from 51 reviews, and I am the single senior point of contact for the whole project. I can share concrete examples in the Freelancer chat. Price: 580 USD, 14 days, one milestone on delivery of the tested API. Question: which SMS provider do you use, and are agents and customers in the same user table or separate ones?
$580 USD in 14 days
8.6
8.6

⭐⭐⭐⭐⭐ Real‑time Chat API Development with MySQL & Secure Auth ❇️ Hi My Friend, I hope you are doing well. I checked all of your project requirements and I can see you are looking for a seasoned backend developer. You have no need to look any further as Zohaib is here to help you! My team is already doing 50+ similar projects for real‑time messaging services. I will build robust REST and websocket endpoints, design the MySQL schema and migrations, and add token‑based auth. I will also provide load‑test scripts and full docs within the same budget. ➡️ Why Me? I can easily do your chat API as I have 5 years of experience in Node.js, Express, WebSockets, MySQL, API security, load testing. Not only this, I have a strong grip on JWT, Docker, CI/CD, and performance tuning. ➡️ Let's have a quick chat to discuss your project in detail and let me show you samples of my previous work. Looking forward to discussing with you in chat. ➡️ Skills & Experience: ✅ Node.js ✅ Express ✅ WebSockets ✅ MySQL ✅ Schema Design ✅ JWT Auth ✅ REST APIs ✅ Load Testing ✅ Docker ✅ CI/CD ✅ Unit Testing ✅ Swagger Docs Waiting for your response! Best Regards, Zohaib
$350 USD in 2 days
8.0
8.0

Hello, I can help you with "Real-Time Support Chat API" as per your given project description. We can discuss more in detail during a chat conversation when you are available. I've worked on many PHP projects in recent times. So I am confident on achieving your expected Goals. Please initiate a communication thread to discuss further and start with the project. ⭐ 5.0/5 from a recent client: "Excellent work. Would definitely utilize again. Stellar job!" Final timeline and cost will be confirmed in chat after a complete understanding and documentation of the project expectations in detail.
$450 USD in 9 days
7.7
7.7

You need a support chat backend where a message lands in under 200 ms at 1k users, and where nobody can open a conversation that isn't theirs. I've fixed a broken REST API response in an existing codebase on the same day, so the REST side is familiar ground. I'd build a websocket gateway on top of a plain message-service layer. The conversation-ownership check runs the same way for REST and socket traffic. Typing indicators and file sharing can then be added later as new event types without touching auth. The load-test script comes with measured numbers against the 200 ms target, and tests aim at the 90% coverage. M1: MySQL schema, token auth, REST endpoints with per-conversation access, 211 USD M2: websocket gateway and outbound SMS, 249 USD M3: tests to 90% coverage, load-test script with measured results, docs, 180 USD Total is 640 USD. That price holds if you use one SMS provider like Twilio and send me the API credentials and a test number. It also assumes standard JWT auth with no SSO or outside identity provider. The 1k-user load test would run on a single modest server, with no multi-region or autoscaling. If any of that differs, I'll re-quote before any work starts. I can start today. What should trigger an SMS, an agent replying while the customer is offline?
$640 USD in 3 days
6.6
6.6

Since 2015, I have been building backend systems from the ground up through hosting, with particular expertise in NestJS APIs, Node.js, PHP, SQL, and MySQL. That experience directly matches your need for a secure, production-ready support chat API with REST endpoints, scalable database design, migrations, and deployment-ready documentation. I build APIs with proper authentication and authorization so users can access only the resources they are permitted to use—essential for protecting agent and customer conversations. My backend development and JavaScript experience also suits the real-time messaging layer, outbound SMS integration, health checks, testing, and clean API documentation. I can structure the service so future capabilities such as file sharing and typing indicators can be added without unnecessary rewrites. I am ready to apply my experience to your real-time support platform and deliver well-organized, secure, maintainable backend code. Choose me to build the API foundation your messaging service can reliably grow on.
$250 USD in 5 days
6.6
6.6

Hello, You need chat that feels instant and stays locked down so each person only sees their own threads. My plan is to keep REST for login, history, and SMS send, and put live message delivery on a websocket layer so replies bounce back fast without constant polling. For the database I would sketch a lean MySQL schema around users, conversations, participants, messages, and delivery status, then ship migrations so setup is repeatable. Queries stay indexed for the hot paths (open threads, newest messages) so things stay snappy when traffic climbs. Auth sits in the middle of every REST call and every socket handshake with short-lived tokens. No token, no chat data. Agents and customers get scoped to conversations they belong to, nothing more. I would leave clear hooks for typing indicators and file uploads later so those can drop in without a rewrite. You get unit tests, a simple load-test script aimed at that sub-200 ms goal under about 1k users, health checks, Postman or Swagger docs, and a README for local setup, env vars, and deploy. Happy to walk through the approach and timeline if this sounds like a fit.
$570 USD in 7 days
6.1
6.1

Building real-time chat with sub-200 ms delivery at 1k users on MySQL needs careful schema design and efficient use of websockets. In a similar project for a customer service platform, I designed scalable schemas with indexing to keep queries fast and lean under load. Using native WS with token-based auth middleware ensured secure message flow where users could only access their conversations. How do you prefer to handle socket reconnections and message queuing during brief network hiccups? Also, do you want the API to support session resumption or just rely on fresh tokens per connection? I will deliver clean REST and websocket endpoints ready to extend for typing indicators and file sharing. Migration scripts will keep schema updates smooth. Tests will cover security and load scenarios, with docs for easy local setup and deployment. Ready to start architecting your real-time chat API and hit your performance and security goals fast.
$250 USD in 7 days
6.0
6.0

My experience building real-time messaging into the Trita ur gaming marketplace directly matches the core of your support chat API. I have delivered 40+ production deployments and work across backend development, API development, JavaScript, PHP, MySQL and Node.js, giving me the foundation to build the chat, SMS and data layers as a dependable production service. I can deliver secured REST and websocket endpoints with token-based access control, conversation ownership checks, MySQL schema and migrations, and a structure that leaves room for future features such as file sharing and typing indicators. My work on BizzallFlow also includes CRM, Stripe and Twilio integrations, relevant to outbound SMS workflows. I can include unit tests, load testing, health checks, API documentation and deployment-focused README documentation while keeping the implementation maintainable and scalable. Choose me to build a secure, production-ready real-time backend with the performance and ownership your platform requires.
$250 USD in 2 days
5.4
5.4

Laravel backend development and optimized MySQL query design are my strongest match for your real-time support chat API. I specialize in building complex backend logic, designing reliable database structures, and writing efficient code for fast, scalable web applications. My PHP and Laravel expertise supports the REST API, authentication middleware, conversation access control, outbound messaging integrations, and maintainable endpoint structure you need. I can also create the MySQL schema and migration scripts with careful attention to query performance, while keeping the architecture extensible for future features such as file sharing and typing indicators. I am committed to clean implementation, secure data access, thorough testing, health checks, and clear API documentation and setup guidance. Choose me to build a dependable backend foundation for your support-chat service, and I will bring the project forward with focused, high-quality Laravel development.
$250 USD in 5 days
5.4
5.4

MySQL and PHP expertise backed by 15+ years in the technical field makes me well suited to build the reliable backend foundation for your support chat API. I can create the MySQL schema and migration scripts, develop secure REST endpoints for chat and outbound SMS, and structure the data layer for clean, scalable queries. I will focus on token-based authentication across both HTTP and real-time endpoints, ensuring conversation data is protected from unauthorised access. My experience with PHP and MySQL supports a maintainable implementation with clear documentation, health checks, testing support, and deployment guidance. I also provide clear communication throughout the project and continued support after delivery. Choose me to develop a quality-focused backend that is structured for future chat features and dependable under load.
$750 USD in 7 days
5.7
5.7

Hi there! I'm Karthik, a seasoned backend developer with over 15 years of experience in architecting and building robust APIs. I’m excited about your project for an instant-response customer-support chat and text-messaging service. Approach: 1. API Design: I will design and implement RESTful and websocket endpoints for chat and SMS, ensuring low-latency communication to meet your requirement of message delivery under 200 ms. 2. MySQL Schema: I’ll create a scalable MySQL schema with migration scripts that ensure efficient data handling under load. 3. Authentication: I will implement a secure token-based authentication middleware to protect user data and ensure that only authorized users can access their conversations. 4. Testing & Documentation: Comprehensive unit tests and a load-test script will be included to verify performance. I will also provide detailed Postman/Swagger documentation along with a README for easy setup and deployment. Experience: I have extensive experience with real-time messaging, using technologies like WebSockets and have a strong focus on secure API design. My previous projects have successfully handled high loads while maintaining performance and security. Timeline: I propose a timeline of [insert estimated duration] to deliver all components as specified. Looking forward to discussing this further and collaborating on your project! Best, Karthik
$800 USD in 7 days
5.6
5.6

Your chat can’t lag or leak. If response time or privacy slip, you lose trust and users. You’ll see chats hit all participants in under 200 ms, every conversation locked to just the right users, and room to add file sharing or typing signals anytime. First I lock down the MySQL schema and user access rules you need. Then I build the REST and websocket endpoints, wire up token auth, and stress test it for speed and security. You get clean docs, migration scripts, and a quick-start README for your team. Clean handover means you run it yourself without needing me on call. Which framework or stack do you prefer for the backend build?
$375 USD in 21 days
4.9
4.9

Hi, I can implement the REST and WebSocket backend with a MySQL schema, migrations and token authentication shared across both transports. I would enforce conversation membership on every read/write, persist messages before acknowledgement, and use message IDs to handle retries safely. Outbound SMS would sit behind a provider adapter so delivery receipts and failures remain traceable. You would receive documented endpoints, health checks, unit/integration tests and a repeatable load script. The 200 ms/1,000-user target should be measured against agreed hosting and test conditions. I work with Node.js, PHP/Python and relational databases. Which SMS provider and authentication system should the service integrate with? Nderim
$700 USD in 14 days
4.7
4.7

Hello, "WEBSOCKET ENDPOINTS" - You need fast, secure support conversations where messages reach the right agents and customers without exposing other users' data. I’ll build the MySQL schema and migrations, REST and WebSocket APIs, token authentication, conversation-level access controls, outbound SMS integration, and health checks. I’ll include unit tests, a load-test script, and Postman or Swagger documentation, while designing the message flow to handle concurrent delivery and reconnects reliably. Is there an SMS provider already selected for outbound messages? Looking forward to working with you. Thanks
$700 USD in 14 days
4.5
4.5

Hello, I checked your project "Real-Time Support Chat API" and already have a clear understanding of your requirements and how to deliver them efficiently. I have solid experience in PHP, JavaScript, MySQL, Backend Development, API Development, and I've successfully completed similar projects by delivering high-quality, scalable, and reliable solutions. Why choose me? * Strong expertise in PHP, JavaScript, MySQL, Backend Development, API Development * Clean, optimized, and scalable implementation * Fast communication and regular progress updates * Focused on delivering results, not just completing the task I'm ready to start immediately and would be happy to discuss the details. Best regards, Umer
$250 USD in 1 day
4.6
4.6

You need a robust backend architecture combining REST endpoints, secure token-based authentication, and a real-time WebSocket layer backed by MySQL to power an instant-response support chat. We would approach this by first designing a clean, scalable MySQL schema and setting up the migration scripts. Next, we would implement the authentication middleware and the core messaging endpoints, using WebSockets for sub-second message delivery. Finally, we would add the requested tests, health checks, and API documentation with Postman or Swagger, structuring the codebase so future additions like file sharing can slot in easily. While our primary focus is systems integration and web development, we frequently build Node.js and database-driven backend services that require strict performance and security standards, similar to our purchase-order automation service linking internal APIs. What specific token-based authentication strategy or framework do you prefer for the middleware?
$365 USD in 7 days
3.6
3.6

Building that real-time support chat API sounds like a fun backend challenge. MySQL and Node will handle the instant responses nicely. What messaging protocol do you plan to use for this?
$450 USD in 7 days
3.4
3.4

You need a MySQL-backed chat API where messages reach every participant in under 200 ms at 1k users, and nobody reads a conversation they don't own. I'd build it in Node.js with native WebSockets alongside a REST layer. One JWT middleware guards both, and ownership is checked per conversation inside the query itself, not just at the route. The schema and migrations index conversations and messages for the hot read paths, and the message pipeline gets a clean extension point so typing indicators and file sharing can be added later. This bid covers the chat core: schema, auth, REST and socket endpoints, tests to 90% coverage, the 1k-user load script, health checks, Swagger and the README. Outbound SMS would be quoted as a later phase once you pick a provider. Will tokens come from an existing identity system, or should this API issue its own for agents and customers?
$452 USD in 4 days
2.6
2.6

Hello, I understand you need a secure, low-latency customer-support chat and SMS backend with REST APIs, WebSockets, and MySQL integration. The goal is to deliver a scalable messaging system with reliable real-time communication. Here’s what I can provide: - Design optimized MySQL schemas, indexing, and migration scripts. - Build REST APIs, WebSocket messaging, and outbound SMS integration targeting sub-200ms delivery. - Implement token-based authentication, conversation-level access control, unit tests, and health checks. I bring over 4+ years of experience in JavaScript, Node.js, MySQL, REST APIs, and Backend Development. I focus on secure, scalable backend architecture, automated testing, and clean documentation. Just to clarify a few things: 1. Which SMS provider would you prefer (Twilio, Vonage, or another)? 2. Do you already have a preferred deployment environment for the backend and WebSocket services? Please come to the chat box to discuss more about your project. Best regards Indresh Kushwaha
$500 USD in 7 days
2.4
2.4

I see you are seeking a backend developer to architect and code a real-time support chat API, with a focus on performance and scalability. I have over 4 years of experience in developing robust APIs and backend systems, particularly with real-time applications. My approach would start with carefully designing the MySQL schema and ensuring efficient migrations, followed by implementing REST and websocket endpoints for seamless chat functionality. I will also establish token-based authentication to secure user access while laying a flexible foundation for future features like file sharing. My commitment to code quality means I will ensure unit tests and documentation are thorough, meeting your acceptance criteria. You can view my relevant project, the Multi-Clinic Appointment SaaS for an idea of my capabilities:
$250 USD in 7 days
0.7
0.7

Attock, Pakistan
Payment method verified
Member since Oct 3, 2026
min $100000 USD
$250-750 USD
$10-30 USD
$250-750 CAD
$250-750 USD
$250-750 USD
₹12500-37500 INR
$250-750 USD
$30-250 USD
$15-25 USD / hour
₹12500-37500 INR
$250-1200 AUD
₹600-1500 INR
$15-25 USD / hour
$250-750 USD
₹1500-12500 INR
₹1500-12500 INR
€8-30 EUR
$3000-5000 USD
$30-250 USD
€12-18 EUR / hour
₹600-1500 INR