The agent-native cloud database
Give your AI agent a full cloud database. Import CSVs from any URL, query with SQL, insert and sync records, and manage tables — all through the Model Context Protocol. Powered by DuckDB via MotherDuck.
How it works
From sign-up to SQL queries in seven steps.
Sign up and get an API key
Create a free account at gentic.co, generate an API key from your dashboard, and use it as a Bearer token to authenticate your agent.
Connect your agent
Add the MCP server URL to Claude Code, Claude Web, OpenClaw, Claude Cowork, ChatGPT, n8n, or any MCP-compatible client. Pass your API key as a Bearer token.
Import your data
Create tables from any publicly accessible CSV — paste a URL from S3, Google Sheets, Google Drive, or any HTTPS endpoint. Your agent handles the rest.
Explore table structure
Use sample_table and get_table_schema to understand your data before querying. Preview rows, check column types, and verify imports.
Query with SQL
Run SELECT queries and CTEs against your data. Your agent writes the SQL — you just describe what you want to know. Full DuckDB SQL support for analytics.
Keep data in sync
Update, append, upsert, or sync tables from fresh CSV sources. Insert individual records or batch insert up to 1,000 rows at once with duplicate prevention.
Build agent workflows
Chain data tools with other Gentic MCP servers — store influencer results, track creative assets, log campaign metrics, or build any custom data pipeline your agent needs.
Available tools
Ten tools your AI agent can call through the Model Context Protocol. All free.
list_database_tables
List all tables in your database with row counts. Use this to see what data you have available.
- -View all tables at a glance
- -Row counts per table
- -Quick database overview
create_table_from_csv
Create a new table by importing data from any CSV URL. Supports S3, HTTPS, Google Sheets, and Google Drive URLs.
- -Auto-converts Google Sheets/Drive URLs
- -S3 and HTTPS support
- -Up to 100 MB file size
sample_table
Preview a table with sample records and column information. Use this to understand table structure before running queries.
- -1–20 sample records
- -Column names and types
- -Quick data preview
get_table_schema
Get detailed schema information including column names, data types, and nullability.
- -Column names and types
- -Nullability info
- -Full schema details
query_data
Execute SQL SELECT queries for data analysis. Supports SELECT and WITH (CTEs). Write operations are blocked for safety.
- -Full DuckDB SQL support
- -CTEs and subqueries
- -Read-only for safety
update_table_from_csv
Update an existing table from a CSV URL. Three modes: replace (drop and recreate), append (add rows), or upsert (add only new rows).
- -Replace, append, or upsert modes
- -Upsert with unique column check
- -Google Sheets/Drive support
sync_table_from_csv
Sync a table with CSV data — updates existing records AND adds new ones in a single operation.
- -Updates + inserts in one call
- -Match by unique column
- -Recommended for refresh workflows
batch_update_table_from_csv
Batch update only existing records from a CSV URL. Ignores new records — use sync_table_from_csv if you need both.
- -Updates only, no inserts
- -Match by unique column
- -Selective record updates
insert_record
Insert a single record into a table with duplicate prevention. Use sample_table first to see the table structure.
- -Single record insert
- -Duplicate prevention
- -Key-value pair input
batch_insert_records
Insert multiple records in one batch operation with duplicate prevention. Maximum 1,000 records per call.
- -Up to 1,000 records per call
- -Duplicate prevention
- -Consistent column format
Connect in seconds
Sign up, grab your API key, and add the server to your agent. Import CSVs, query data, and manage tables. Works with Claude Code, Claude Web, OpenClaw, Claude Cowork, ChatGPT, n8n, and any MCP client.
claude mcp add gentic-data \
--transport http \
https://mcp.gentic.co/data \
--header "Authorization: Bearer YOUR_API_KEY"You can also connect via OAuth — just add Gentic Data as a connector in Claude or ChatGPT settings. No API key needed; authentication is handled automatically.
Install the Gentic agent skill to teach your agent the optimal workflow — checking tables, importing CSVs, exploring schemas, querying data, and syncing records — so it gets the best results automatically.
npx skills add gentic-co/agent-skillsWorks with Claude Code, Cursor, Copilot, and 40+ other agents.
Completely free
All 10 data tools are free. No usage limits on tool calls. No subscriptions. No seat licenses.
| Action | Cost |
|---|---|
| list_database_tables | Free |
| create_table_from_csv | Free |
| sample_table | Free |
| get_table_schema | Free |
| query_data | Free |
| update_table_from_csv | Free |
| sync_table_from_csv | Free |
| batch_update_table_from_csv | Free |
| insert_record | Free |
| batch_insert_records | Free |
Why free?
Gentic Data gives every organization its own cloud database powered by DuckDB via MotherDuck. All data operations — imports, queries, inserts, syncs — are included at no cost. Your data stays scoped to your organization and is never shared.
Why agent-native?
Traditional databases weren't built for AI agents. This one was.
No UI to learn
Your AI agent is the interface. Describe the data you need in natural language — import CSVs, run queries, insert records — no dashboards or SQL editors required.
Composable workflows
Chain data tools with influencer search, creative generation, and any other MCP server. Build end-to-end data pipelines your way.
Portable
Works with any MCP-compatible client — Claude Web, Claude Code, OpenClaw, ChatGPT, n8n, and more. Switch clients without changing a thing.
Completely free
All 10 data tools are free forever. No usage limits on tool calls. No monthly seats or platform fees.