What is Mammoth Analytics? Features and who it's for
Mammoth Analytics is a no-code data platform for business teams. You bring data in from files and connectors, clean and combine it in a visual pipeline, keep it current with automations, and share it as exports, dashboards, docs and slides. It runs in the cloud with nothing to install, so analysts, operations managers and domain experts do the work themselves without writing code.
The data preparation problem Mammoth solves
Business teams often spend more time preparing data than analysing it. Spreadsheets have row limits and don't repeat last month's steps. Data preparation tools need technical training, BI tools need clean data, and IT becomes a bottleneck for simple requests. Mammoth turns those manual steps into a pipeline that runs again on new data.
How Mammoth works: connect, transform, export
Most work follows three steps: connect a source, transform it in a pipeline, and export the result. The full journey has six stages. Prepare data tours the first four, and Automate and share data the last two.
| Stage | What you use | Learn more |
|---|---|---|
| Connect | File upload, paste, From URL, webhooks and connectors. Each source becomes a dataset in the Data Library. | Choose how to bring data in |
| Explore | Explore Cards above the data grid | Explore cards |
| Assess | View Data Quality (footer) scores the view and recommends tasks; View Insights (action bar) turns column statistics into plain-language observations | Data quality report, View insights |
| Transform | Pipeline tasks, including AI tasks such as Generative AI and Ask in plain words | How the pipeline works |
| Automate | Five automation types | What you can automate |
| Share | Downloads, exports, live links, and dashboards, docs and slides built by AI | Download data, Dashboards |
To try the steps in order, follow the Quick start.
Use the AI Agent, MCP server, CLI and API
| Tool | What it does | Plans |
|---|---|---|
| AI Agent | A chat in the web app (Agent in the left navigation). It answers questions about your data, makes charts, cleans and combines data, and builds dashboards, never doing more than your own access allows. Includes Ask mode and the Today page. | The AI Agent is available on Enterprise plans. |
| Mammoth MCP server | Hosted at https://mcp.mammoth.io/mcp. Lets an AI client such as Claude or ChatGPT explore, clean, transform and export your data, signed in as you. | Every plan |
| CLI | The mammoth command for terminals, scripts and CI. Coding agents such as Claude Code use it through a bundled skill (Mammoth for coding agents). | Every plan |
| REST API | The API behind both, for anything else you build. | See Build with Mammoth |
Control access with projects and roles
A project holds a team's datasets, connections, automations and dashboards. Each member has a project role:
| Role | What they can do |
|---|---|
| Project Admin | Everything an editor can, plus edit project settings, manage members, manage connections and delete the project |
| Project Editor | Create and change datasets, views, pipelines and automations |
| Project Viewer | View Data Library items, read-only |
Workspace roles are Workspace Owner and Workspace Member. On the Pro plan you can also build custom workspace and project roles. See Members, roles and custom roles.
Who Mammoth is for
| Who | How they use Mammoth |
|---|---|
| Business analysts | Excel users who rebuild the same weekly or monthly report by hand, for example combining reports from several sources. The pipeline runs again on new data. |
| Technical enablers | IT and analytics teams who field many small data requests. They connect the sources once, give business users a project, and use the REST API, the CLI or the MCP server where code helps. |
| Operations managers | Leaders who oversee their teams' data work. Projects and roles control who can see and change data, Monitor shows what needs attention, and the Activity Log records who changed what. |
From Excel, start with file uploads and Explore Cards. From Alteryx or a similar tool, go straight to connectors and the advanced pipeline tasks. Pick your path has a plan for each role.
What Mammoth is not
- Not a data warehouse. Mammoth stores the data you are working on, within your plan's storage. For long-term analytical storage, export results to a warehouse such as Snowflake or Amazon Redshift.
- Not for data science modelling. It is for data preparation and business reporting, not machine learning models in Python or R.
- Not for real-time streaming. It processes data in runs, on a schedule or when data arrives, not as a sub-second event stream.
- Not a code-first ETL tool. If your team prefers to write and maintain Python or SQL scripts, a code-based ETL tool may fit better.
Security, certifications and sign-in
Mammoth is SOC 2 Type II and ISO 27001 certified. Projects and roles decide who can see and change each project's data. SSO (SAML or OIDC), enforced MFA and an IP allowlist are set up by Mammoth on request. See Security: sign-in, data security, compliance and audit logs.
To try Mammoth with your own data, sign up at mammoth.io/signup.
Related
- Quick start: try the whole workflow on a small file.
- Core ideas: how workspaces, projects, datasets, views and pipelines fit together.
- Set up your workspace: first steps for a Workspace Owner.
- Limits and quotas: file sizes, schedule intervals and plan allowances.
Something wrong? support@mammoth.io