Flutter Template

CRM App Backend Template
Flutter — Schema, API & AI Guide

A production-ready Flutter CRM backend schema and Starter Kit on Back4app: Contact, Company, Deal, Activity, pipeline stages, ER diagram, data dictionary, JSON schema, API playground, and a one-click AI Agent prompt to deploy in minutes.

Key Takeaways

On this page you get a production-ready CRM schema, a one-click AI prompt, and step-by-step Flutter code — so you can ship a CRM app without building the backend.

  1. Deploy in minutesPaste the AI Agent prompt and get a running app with contacts, companies, deals, and pipeline.
  2. Secure by defaultACLs and role-based access so users see only their assigned deals and data.
  3. Flutter-native SDKTyped objects, async/await, offline pinning, and Live Queries for pipeline updates.
  4. REST + GraphQLBoth APIs auto-generated; filter deals by stage, list activities by relatedTo.
  5. Five classes_User (built-in), Company, Contact, Deal (pipeline), Activity (tasks/events).

What Is the Flutter CRM App Backend Template?

The Flutter CRM App Backend Template is a production-ready Back4app schema (Contact, Company, Deal, Activity) with a typed Dart SDK, offline pinning, and Live Queries. Build a single codebase for iOS and Android: query deals by stage, manage contacts and companies, and sync pipeline data in real time. No custom backend or REST glue — the Back4app Flutter SDK handles auth, CRUD, and local storage so you focus on UI and business logic.

Best for:

Sales teamsCRM buildersRapid prototypingField repsMVP launchesTeams choosing a BaaS for CRM

Overview

Flutter CRM apps need contacts, deals, pipeline stages, and optional offline sync. Back4app's schema (Company, Contact, Deal, Activity) fits the Flutter SDK: QueryBuilder for filtering by stage, pinning for local storage, and Live Queries for real-time pipeline updates.

The five classes below — _User, Company, Contact, Deal, Activity — are exposed via the Back4app Flutter SDK. Use Dart types and async/await to fetch deals by stage, create contacts and deals, and log activities. No REST or GraphQL wiring in your app; the SDK handles serialization and sync.

Core CRM Features

With Flutter and the Parse SDK you get contact management, deal pipeline, and activity tracking — plus offline pinning and Live Queries for a complete CRM backend.

Contact management

Store and manage contacts with name, email, phone, company, and notes. Ideal for Flutter apps.

Company management

Track companies with name, website, industry, and address. Links to contacts and deals.

Deal pipeline

Sales pipeline with stages, amount, expected close date, and assignment. Built for Flutter backends.

Activity tracking

Log calls, emails, meetings, and notes linked to contacts and deals. Works with Flutter SDK.

User & permissions

Built-in user model and pointers for ownership and assignment. ACLs out of the box for Flutter.

Why Build Your Flutter CRM Backend with Back4app?

Back4app gives you a ready backend and a typed SDK so you can build your CRM app with pipeline, contacts, and deals without writing REST glue or managing auth yourself.

  • Typed SDK & serialization: The SDK's typed objects keep Contact, Company, Deal, and Activity type-safe; the SDK handles JSON so you write less boilerplate.
  • Async-first & offline: The Back4app Flutter SDK uses async/await and pinning; pipeline and contacts work offline and sync when back online.
  • Live Queries / reactive sync: Subscribe to Deal and Activity changes so the pipeline and dashboard update in real time.

Same schema and APIs for every stack—switch clients later without changing the backend.

Core Benefits

A production-ready CRM backend so you can ship faster and focus on your app.

Ship Faster, No Backend Code

REST & GraphQL APIs and a ready-to-use schema — connect your app and go.

Secure by Default

ACLs and class-level permissions; restrict by assignedTo and createdBy.

Real-Time Pipeline

Live Queries over WebSockets for instant deal and activity updates.

Built-In Auth

User sign-up, login, and session handling out of the box.

Works Offline

Local pinning keeps contacts and deals available offline and syncs when you reconnect.

Deploy in Minutes

Use the AI Agent to create and deploy your CRM app from this template.

Ready to try it?

Let the Back4app AI Agent create your CRM app backend, connect the Flutter frontend, and deploy — all from a single prompt.

Free to start — 50 AI Agent prompts/month, no credit card required

Technical Stack

Everything powering this CRM app template at a glance.

Frontend
Flutter
Backend
Back4app
Database
MongoDB
Auth
Auth & Access Control
APIs
REST & GraphQL
Deployment
AI Agent / Dashboard

ER Diagram

Entity-Relationship diagram for the Flutter CRM app data model.

View diagram source
Mermaid
erDiagram
    _User {
        String objectId PK
        String username
        String email
        String password
        Date createdAt
        Date updatedAt
    }

    Company {
        String objectId PK
        String name
        String website
        String industry
        String address
        String notes
        Pointer createdBy FK
        Date createdAt
        Date updatedAt
    }

    Contact {
        String objectId PK
        String name
        String email
        String phone
        Pointer company FK
        String notes
        Pointer createdBy FK
        Date createdAt
        Date updatedAt
    }

    Deal {
        String objectId PK
        String title
        Number amount
        String stage
        Pointer contact FK
        Pointer company FK
        Date expectedCloseDate
        String notes
        Pointer assignedTo FK
        Date createdAt
        Date updatedAt
    }

    Activity {
        String objectId PK
        String type
        String subject
        String description
        Date dueDate
        Date completedAt
        Pointer relatedTo FK
        Pointer createdBy FK
        Date createdAt
        Date updatedAt
    }

    Company ||--o{ Contact : "has"
    Company ||--o{ Deal : "has"
    Contact ||--o{ Deal : "has"
    _User ||--o{ Deal : "assignedTo"
    _User ||--o{ Activity : "createdBy"
    Contact ||--o{ Activity : "relatedTo"
    Deal ||--o{ Activity : "relatedTo"
    _User ||--o{ Company : "createdBy"
    _User ||--o{ Contact : "createdBy"

Integration Flow

Auth-to-CRUD sequence: how your Flutter app talks to Back4app — login, then query contacts and deals, update pipeline.

View diagram source
Mermaid
sequenceDiagram
  participant User
  participant App as Flutter App
  participant Back4app as Back4app Cloud

  User->>App: Login
  App->>Back4app: Parse().login(username, password)
  Back4app-->>App: Session token
  App-->>User: Logged in

  User->>App: Load contacts and deals
  App->>Back4app: Query<Deal>().find() or Query<Contact>().find()
  Back4app-->>App: List<Deal> / List<Contact>
  App-->>User: Show pipeline

  User->>App: Create deal or contact
  App->>Back4app: deal.save() or contact.save()
  Back4app-->>App: Deal (objectId)
  App-->>User: Updated list

Data Dictionary

Complete field reference for every class in the schema.

FieldTypeDescriptionRequired
objectIdStringAuto-generated unique identifierauto
nameStringFull name of the contact
emailStringEmail address
phoneStringPhone number
companyPointer<Company>Company this contact belongs to
notesStringFree-form notes
createdByPointer<_User>User who created this contact
createdAtDateAuto-generated creation timestampauto
updatedAtDateAuto-generated last-update timestampauto

9 fields in Contact

Security & Permissions

How ownership, ACLs, and class-level permissions protect data in this CRM schema.

Row-Level ACLs

Use ACLs and pointers (assignedTo, createdBy) so users only see and edit their assigned deals and related data.

Class-Level Permissions

CLPs restrict which roles or users can create, read, update, or delete objects at the class level.

Pointer-Based Ownership

Deal.assignedTo and Activity.createdBy link to _User; Cloud Code can enforce visibility and edits by role.

Schema (JSON)

Raw JSON schema definition — copy and use in your Back4app app or import via the API.

JSON
{
  "classes": [
    {
      "className": "Contact",
      "fields": {
        "objectId": {
          "type": "String",
          "required": false
        },
        "name": {
          "type": "String",
          "required": true
        },
        "email": {
          "type": "String",
          "required": false
        },
        "phone": {
          "type": "String",
          "required": false
        },
        "company": {
          "type": "Pointer",
          "targetClass": "Company",
          "required": false
        },
        "notes": {
          "type": "String",
          "required": false
        },
        "createdBy": {
          "type": "Pointer",
          "targetClass": "_User",
          "required": false
        },
        "createdAt": {
          "type": "Date",
          "required": false
        },
        "updatedAt": {
          "type": "Date",
          "required": false
        }
      }
    },
    {
      "className": "Company",
      "fields": {
        "objectId": {
          "type": "String",
          "required": false
        },
        "name": {
          "type": "String",
          "required": true
        },
        "website": {
          "type": "String",
          "required": false
        },
        "industry": {
          "type": "String",
          "required": false
        },
        "address": {
          "type": "String",
          "required": false
        },
        "notes": {
          "type": "String",
          "required": false
        },
        "createdBy": {
          "type": "Pointer",
          "targetClass": "_User",
          "required": false
        },
        "createdAt": {
          "type": "Date",
          "required": false
        },
        "updatedAt": {
          "type": "Date",
          "required": false
        }
      }
    },
    {
      "className": "Deal",
      "fields": {
        "objectId": {
          "type": "String",
          "required": false
        },
        "title": {
          "type": "String",
          "required": true
        },
        "amount": {
          "type": "Number",
          "required": false
        },
        "stage": {
          "type": "String",
          "required": false
        },
        "contact": {
          "type": "Pointer",
          "targetClass": "Contact",
          "required": false
        },
        "company": {
          "type": "Pointer",
          "targetClass": "Company",
          "required": false
        },
        "expectedCloseDate": {
          "type": "Date",
          "required": false
        },
        "notes": {
          "type": "String",
          "required": false
        },
        "assignedTo": {
          "type": "Pointer",
          "targetClass": "_User",
          "required": false
        },
        "createdAt": {
          "type": "Date",
          "required": false
        },
        "updatedAt": {
          "type": "Date",
          "required": false
        }
      }
    },
    {
      "className": "Activity",
      "fields": {
        "objectId": {
          "type": "String",
          "required": false
        },
        "type": {
          "type": "String",
          "required": false
        },
        "subject": {
          "type": "String",
          "required": false
        },
        "description": {
          "type": "String",
          "required": false
        },
        "dueDate": {
          "type": "Date",
          "required": false
        },
        "completedAt": {
          "type": "Date",
          "required": false
        },
        "relatedTo": {
          "type": "Pointer",
          "required": false
        },
        "createdBy": {
          "type": "Pointer",
          "targetClass": "_User",
          "required": false
        },
        "createdAt": {
          "type": "Date",
          "required": false
        },
        "updatedAt": {
          "type": "Date",
          "required": false
        }
      }
    },
    {
      "className": "_User",
      "fields": {
        "objectId": {
          "type": "String",
          "required": false
        },
        "username": {
          "type": "String",
          "required": true
        },
        "email": {
          "type": "String",
          "required": true
        },
        "password": {
          "type": "String",
          "required": true
        },
        "createdAt": {
          "type": "Date",
          "required": false
        },
        "updatedAt": {
          "type": "Date",
          "required": false
        }
      }
    }
  ]
}

Build with AI Agent

Use the Back4app AI Agent to build a real CRM app from this template: it will create the frontend, the backend (this schema, auth, and APIs), and deploy it — no manual setup. The prompt below describes this CRM stack so the Agent can generate a production-ready app in one go.

Back4app AI Agent
Ready to build
Create a CRM app on Back4app with this exact schema and behavior.

Schema:
1. _User (use Back4app built-in): username (String, required), email (String, required), password (String, required); objectId, createdAt, updatedAt (system).
2. Company: name (String, required), website (String), industry (String), address (String), notes (String), createdBy (Pointer to _User); objectId, createdAt, updatedAt (system).
3. Contact: name (String, required), email (String), phone (String), company (Pointer to Company), notes (String), createdBy (Pointer to _User); objectId, createdAt, updatedAt (system).
4. Deal: title (String, required), amount (Number), stage (String; e.g. lead, qualified, proposal, negotiation, won, lost), contact (Pointer to Contact), company (Pointer to Company), expectedCloseDate (Date), notes (String), assignedTo (Pointer to _User); objectId, createdAt, updatedAt (system).
5. Activity: type (String; e.g. call, email, meeting, note), subject (String), description (String), dueDate (Date), completedAt (Date), relatedTo (Pointer to Contact or Deal), createdBy (Pointer to _User); objectId, createdAt, updatedAt (system).

Security:
- Set ACLs so only authenticated users can access data; use role-based or owner-based rules where appropriate (e.g. assignedTo, createdBy).
- Use Class-Level Permissions so only authenticated users can create/read/update/delete these classes.

Auth:
- Sign-up (username, email, password) and login; support logout/session.

Behavior:
- Full CRUD for Company, Contact, Deal, and Activity.
- List deals with filter by stage and order by expectedCloseDate or updatedAt (pipeline view).
- List activities by relatedTo (Contact or Deal).
- Optional: real-time Live Queries for Deal and Activity for dashboard/pipeline updates.
- Optional: offline pinning for mobile (Contacts, Deals, Activities).

Deliver:
- Create the Back4app app with the schema above, ACLs, and any Cloud Code needed.
- Generate the frontend and connect it to this backend; deploy so the app is runnable end-to-end.

Press the button below to open the Agent with this template's prompt pre-filled.

Deploy in minutes50 free prompts / monthNo credit card required

API Playground

Try the REST and GraphQL endpoints for the CRM schema. Responses from the example data above — no Back4app account needed.

Loading playground…

Uses the same CRM schema (Contact, Company, Deal, Activity) as this template.

Step-by-Step Flutter Integration

Connect to your Back4app backend from a Flutter app using the Back4app Flutter SDK.

  1. Step 1: Install Back4app Flutter SDK

    Add the Back4app SDK for your stack (e.g. npm, pubspec, or package manager).

    YAML
    dependencies:
      flutter:
        sdk: flutter
      parse_server_sdk_flutter: ^7.0.0
  2. Step 2: Initialize Back4app in your app

    Initialize the Back4app SDK at app startup with your App ID and server URL.

    Dart
    import 'package:parse_server_sdk_flutter/parse_server_sdk_flutter.dart';
    
    void main() async {
      WidgetsFlutterBinding.ensureInitialized();
    
      await Parse().initialize(
        'YOUR_APP_ID',
        'https://parseapi.back4app.com',
        clientKey: 'YOUR_CLIENT_KEY',
        autoSendSessionId: true,
      );
    
      runApp(const MyApp());
    }
  3. Step 3: Query contacts and deals

    Use the SDK to fetch Contact and Deal objects; filter deals by stage for the pipeline.

    Dart
    Future<List<ParseObject>> getDeals({String stage = 'qualified'}) async {
      final query = QueryBuilder<ParseObject>(ParseObject('Deal'))
        ..whereEqualTo('stage', stage)
        ..orderByAscending('expectedCloseDate');
    
      final response = await query.query();
      if (response.success && response.results != null) {
        return response.results as List<ParseObject>;
      }
      return [];
    }
    Future<List<ParseObject>> getContacts() async {
      final query = QueryBuilder<ParseObject>(ParseObject('Contact'));
      final response = await query.query();
      if (response.success && response.results != null) {
        return response.results as List<ParseObject>;
      }
      return [];
    }
  4. Step 4: Create a contact or deal

    Create a new Contact or Deal with the required fields and pointers (company, contact, assignedTo), then save.

    Dart
    Future<void> createDeal(String title, {String stage = 'lead', double? amount}) async {
      final deal = ParseObject('Deal')
        ..set('title', title)
        ..set('stage', stage);
      if (amount != null) deal.set('amount', amount);
      await deal.save();
    }
    Future<void> createContact(String name, {String? email, String? phone}) async {
      final contact = ParseObject('Contact')..set('name', name);
      if (email != null) contact.set('email', email);
      if (phone != null) contact.set('phone', phone);
      await contact.save();
    }
  5. Step 5: Update deal stage and activities

    Update Deal.stage when moving in the pipeline; create and list Activity by relatedTo.

    Dart
    // Update deal stage (e.g. move in pipeline)
    Future<void> updateDealStage(String objectId, String stage) async {
      final deal = ParseObject('Deal')..objectId = objectId;
      deal.set('stage', stage);
      await deal.save();
    }
    
    // Delete a deal
    Future<void> deleteDeal(String objectId) async {
      final deal = ParseObject('Deal')..objectId = objectId;
      await deal.delete();
    }

State Management Integration

Integrate the Back4app SDK with your app's state layer (e.g. context, store, or services) for pipeline and contact state.

Full Data Model

Copy a complete CRM model for type-safe serialization (e.g. class, interface, or type definition).

Dart
class Deal {
  final String? objectId;
  final String title;
  final double? amount;
  final String? stage;
  final DateTime? expectedCloseDate;
  final String? contactId;
  final String? companyId;
  final String? assignedToId;
  final DateTime? createdAt;
  final DateTime? updatedAt;

  Deal({
    this.objectId,
    required this.title,
    this.amount,
    this.stage = 'lead',
    this.expectedCloseDate,
    this.contactId,
    this.companyId,
    this.assignedToId,
    this.createdAt,
    this.updatedAt,
  });

  factory Deal.fromJson(Map<String, dynamic> json) {
    return Deal(
      objectId: json['objectId'] as String?,
      title: json['title'] as String,
      amount: (json['amount'] as num?)?.toDouble(),
      stage: json['stage'] as String? ?? 'lead',
      expectedCloseDate: json['expectedCloseDate'] != null ? DateTime.parse(json['expectedCloseDate']) : null,
      contactId: json['contact'] is Map ? (json['contact'] as Map)['objectId'] as String? : null,
      companyId: json['company'] is Map ? (json['company'] as Map)['objectId'] as String? : null,
      assignedToId: json['assignedTo'] is Map ? (json['assignedTo'] as Map)['objectId'] as String? : null,
      createdAt: json['createdAt'] != null ? DateTime.parse(json['createdAt']) : null,
      updatedAt: json['updatedAt'] != null ? DateTime.parse(json['updatedAt']) : null,
    );
  }
}

Offline-First & Local Datastore

Use pin() and unpin() so contacts and deals are available offline and sync when back online.

Supported SDKs include a local datastore. Pin Contact, Deal, and Activity objects to keep them on device; query pinned data when offline. When the app is back online, sync with the server.

Below: pin results after fetch, and unpin when you no longer need local copies.

Dart
// Pin deals after fetch (offline-first)
Future<void> fetchAndPinDeals() async {
  final query = QueryBuilder<ParseObject>(ParseObject('Deal'))
    ..whereEqualTo('stage', 'qualified')
    ..orderByDescending('expectedCloseDate');
  final response = await query.query();
  if (response.success && response.results != null) {
    final results = response.results!.cast<ParseObject>();
    await ParseObject.pinAllObjects(results);
    // Now query from local store when offline:
    // QueryBuilder<ParseObject>(ParseObject('Deal')).fromLocalDatastore();
  }
}

// Unpin when no longer needed
Future<void> unpinAllDeals() async {
  await ParseObject.unpinAll('Deal');
}

Frequently Asked Questions

Common questions about the CRM app backend template.

What is Back4app?
Why use Back4app for a Flutter CRM app?
How do I query deals by stage in Flutter?
Does the Flutter SDK support offline CRM data?

Trusted by developers worldwide

Join the community building the future of apps

G2 Users Love Us Badge

Ready to Build Your CRM App?

Start your Flutter project in minutes. No credit card required.

Build with AI Agent