Client database software: which kind fits your team

Client database software keeps one record per client: who they are, which company they belong to, what you agreed and what work is still open, findable by everyone on the team. For a small service business the practical answer is usually a light CRM, because it links people, companies and ongoing work without you building anything. A no-code database such as Airtable or Ninox fits when your records don't look like clients and deals. And a spreadsheet is still fine if you work alone with a short list.

Below you'll find the four kinds of software that show up for this search, what each free plan allows before it stops, a 30-minute test to run on any trial, and a client database set up in Customermates. Customermates publishes this guide and appears in its own labelled section. Vendor details were checked on 8 October 2026 against each vendor's own pages, linked at the end.

Four kinds of software sold as a client database

Search for client database software and you get CRMs, database builders, accounting tools with a customer list and industry suites for studios or practices. They solve different problems, so pick the kind first and the product second.

A common trap for small businesses: they want a simple list of clients and only find full industry suites with bookings and payments. If you need bookings, that suite is the right category. If you need to know who your clients are and what you agreed with them, a CRM or a database is the lighter tool. And if you want to see how far a well-built sheet goes first, the Excel CRM template is a reasonable starting point.

The 30-minute trial test

Feature lists look alike. These checks separate tools in half an hour, using your own data on any trial or free plan.

1. Import 50 real rows

   Take 50 rows from your current list, including a messy one with a missing name. Watch how the importer maps your columns and what it does with the bad row: reject it, skip it, or import it broken without telling you.

2. Add a duplicate on purpose

   Create a person who already exists, with the same email address. A good tool stops you or warns you. A weak one creates a second record and splits that client's history in two.

3. Link a person to a company

   Open the company afterwards. It should list all its people and their open work without you building a lookup.

4. Add the fields you really filter on

   For example "Client since" as a date, "Segment" as a single choice and the billing address as text. Then filter on each one. A field you can't filter on is a note, not data.

5. Search like you will in a hurry

   Search by part of a surname, by an email address and by a company name. Each search should find the client.

6. Export everything and open the file

   If the export drops custom fields or the link between person and company, your exit will drop them too.

If the team needs it, add a sixth check: give a colleague access to their own clients only and see what they can still open.

Free client database software: what the free plans cover

Free plans are real, but each one stops at a different wall. Limits as listed on each vendor's page on 8 October 2026:

Pipedrive has no free plan and offers a 14-day free trial. Customermates Cloud has no free plan either; its trial runs 7 days.

How to read the table: two people with fewer than 1,000 contacts can start on HubSpot's free tools without trouble. Three people fit Zoho's free edition. If you'd rather design your own tables, look at Airtable or Ninox. If someone on the team runs servers, a self-hosted open-source CRM removes the per-user fee, but not the work.

What it costs once you pay

Most cloud tools charge per user and month. Prices checked on 8 October 2026 from the vendors' pricing pages (Airtable plans, Ninox pricing); Ninox lists its prices excluding VAT. For a team of three:

Airtable and Ninox are database builders, so that price buys the tables and you build the client logic on top. HubSpot, Zoho and Pipedrive publish their paid plans on the pricing pages linked above; check them in your own currency and billing term before you compare. Customermates plans and what each one includes are on the pricing page.

A client database in Customermates, step by step

Customermates is an open-source, AI-native CRM built in Germany for small client-facing teams such as consultants, agencies and founders. Here is a client database for a small consultancy, set up the way the product works today.

1. Name the records the way you talk

   In Configure, open a list and change its Name and Plural name under General: rename Contacts to Clients and Organizations to Companies. Deals can become Projects, and Tasks can become Follow-ups. Any name works, and it applies to the whole workspace.

2. Add the fields you will filter on

   On Companies, add "Segment" as a Single choice field with Retainer, Project and Former, and "Client since" as a Date field. On Clients, add "Billing address" as an Address field. Phone numbers and email addresses go into the Contact details field, which the Clients list has from the start.

3. Import companies first, then people

   Use More actions › Add from file with an .xlsx workbook, one list per import. Import the companies, then the people sheet with a column that holds each person's company name: the wizard matches link columns by record name, and email and phone columns can be matched to the client's Contact details field. The importer does not accept CSV, so save those files as .xlsx first. One workbook currently takes up to 5,000 rows.

4. Save three views

   On Companies, "Retainer clients" filters Segment to Retainer. On Clients, "Untouched for 90 days" filters Updated at with Older than… 90 days. "Clients without a company" filters for clients with no linked company. Saved views are personal, so each colleague sets the same filters and saves their own view.

5. Connect conversations (Pro)

   On Pro, each user connects 1 account, such as Gmail, Outlook, LinkedIn or WhatsApp, and the unified inbox shows those threads next to the client. Starter has no inbox.

Two things the trial test above will show. Customermates lets one email address belong to several records, so it does not stop that duplicate: search for the address before you add a client. And search finds a client by name or by any email address or phone number in their contact details. The import rules are documented on the records page of the docs.

In Customermates Cloud, a routine for new clients. Mate, the assistant in Customermates Cloud, uses hosted AI credits. A routine runs saved instructions on a schedule or on a record event, as the person who owns it, and Starter includes 1 routine per user. A routine triggered by Record created on Clients could carry this instruction:

The last two sentences matter. Mate can send messages when an instruction asks for it, so a routine that should only tidy records has to say so. If you'd rather use your own AI client, Claude, ChatGPT and other MCP clients can read and update the same records through MCP, and that works when you self-host too.

When Customermates is the wrong client database

• You only need names and addresses for invoicing. The customer list in your accounting software is enough, and Customermates has no quotes or invoicing.
• You send newsletters. There is no mass email in Customermates. Use an email marketing tool.
• You take bookings or appointments. Customermates has no booking. Look at industry software for your trade.
• You mostly work from your phone. There is no native mobile app.
• Your data model isn't people and companies. Customermates starts without lists and lets you create your own, but it is built around people, companies and deals. Equipment, properties or events with nothing to sell may fit better in Airtable or Ninox.
• You want to self-host and keep the inbox. Self-hosting is the AGPL core with REST, webhooks and MCP. The unified inbox and Mate are not part of it.

Where the client data lives

A client database holds personal data. In the EU, a cloud provider that stores it for you is a processor, and Article 28 GDPR requires a contract with it, the data processing agreement. Before you import, check where the database runs, who the subprocessors are, and whether you can get all your data back out.

Ninox lists Germany as the server region on its pricing page. Customermates Cloud has its primary database configured in the AWS Frankfurt region; that is a product setting, not a contractual residency guarantee, and the subprocessors, US providers included, are on the subprocessors page. The data processing agreement is public. On the way out, Customermates exports each list to an Excel workbook or JSON; there is no single whole-account export. Self-hosting puts the database on your own server.

Frequently asked questions

Vendor details checked on 8 October 2026 against HubSpot pricing, Zoho CRM pricing, Airtable plans, Ninox pricing, Notion pricing, Pipedrive pricing, EspoCRM download and SuiteCRM on GitHub.