@iadev/mcp-server
Allows Windsurf (by Codeium) to interact with the project database for table management, SQL execution, and user administration.
Integrates with VS Code GitHub Copilot to enable AI-powered database operations directly from the editor.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@@iadev/mcp-server list tables in my project"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
@iadev/mcp-server
MCP Server para iadev.dev — conecte qualquer IA ao seu projeto.
Permite que VS Code Copilot, Cursor, Windsurf, Claude Desktop e qualquer plataforma compatível com MCP operem diretamente no seu banco — tabelas, SQL, usuários — sem sair do editor.
Instalação rápida
Não precisa instalar globalmente. Use npx direto:
npx -y github:iadevhub/iadev-mcp-serverRelated MCP server: Database MCP Server
Configuração
VS Code — GitHub Copilot
Criar arquivo .vscode/mcp.json na raiz do projeto:
{
"servers": {
"iadev": {
"command": "npx",
"args": ["-y", "github:iadevhub/iadev-mcp-server"],
"env": {
"IADEV_URL": "https://iadev.dev",
"IADEV_PROJECT": "SEU_SLUG",
"IADEV_API_KEY": "SUA_API_KEY"
}
}
}
}Cursor
Criar arquivo .cursor/mcp.json:
{
"mcpServers": {
"iadev": {
"command": "npx",
"args": ["-y", "github:iadevhub/iadev-mcp-server"],
"env": {
"IADEV_URL": "https://iadev.dev",
"IADEV_PROJECT": "SEU_SLUG",
"IADEV_API_KEY": "SUA_API_KEY"
}
}
}
}Windsurf
Abrir Settings → MCP ou criar ~/.codeium/windsurf/mcp_config.json:
{
"mcpServers": {
"iadev": {
"command": "npx",
"args": ["-y", "github:iadevhub/iadev-mcp-server"],
"env": {
"IADEV_URL": "https://iadev.dev",
"IADEV_PROJECT": "SEU_SLUG",
"IADEV_API_KEY": "SUA_API_KEY"
}
}
}
}Claude Desktop
Editar claude_desktop_config.json (menu Settings → Developer):
{
"mcpServers": {
"iadev": {
"command": "npx",
"args": ["-y", "github:iadevhub/iadev-mcp-server"],
"env": {
"IADEV_URL": "https://iadev.dev",
"IADEV_PROJECT": "SEU_SLUG",
"IADEV_API_KEY": "SUA_API_KEY"
}
}
}
}Variáveis de ambiente
Variável | Obrigatória | Descrição |
| Sim | URL da API (padrão: |
| Sim | Slug do projeto |
| Recomendada | API Key para auto-autenticação |
Tools disponíveis (15)
Tool | Descrição |
| Autenticar como admin do projeto |
| Trocar API Key por JWT técnico |
| Informações do projeto |
| Listar tabelas do schema |
| Listar colunas de uma tabela |
| Buscar dados paginados |
| Executar SQL (DDL/DML) |
| Listar usuários do projeto |
| Criar usuário |
| Atualizar usuário |
| Criar novo projeto IAdev |
| Listar meus projetos |
| Provisionar com infra (super_admin) |
| Conectar repo + deploy |
| Status do deployment |
Segurança
A IADEV_API_KEY é usada para auto-autenticação. O token gerado tem papel service e acessa apenas o schema do seu projeto. Nunca compartilhe a API Key em repositórios públicos — use variáveis de ambiente ou .env.
Licença
MIT
Available Tools
15 toolscreate_projectA
Criar um novo projeto IAdev (banco + schema + API key). Admin ou super_admin.
Inputs: nome (required).
create_userC
Criar um novo usuário no projeto.
Inputs: nome (required), email (required), senha (required), perfil.
deploy_statusB
Consultar status do deployment. Admin (dono) ou super_admin.
Inputs: slug (required), deploymentId.
execute_sqlB
Executar SQL no schema do projeto. Use com cuidado — suporta DDL e DML.
Inputs: sql (required).
get_columnsC
Listar colunas de uma tabela específica.
Inputs: table (required).
get_project_infoB
Informações do projeto atual (nome, slug, plano, status).
Inputs: no named parameters.
get_service_tokenB
Trocar API Key por um JWT técnico. Usa IADEV_API_KEY se apiKey não for informada.
Inputs: apiKey.
list_my_projectsC
Listar meus projetos IAdev.
Inputs: no named parameters.
list_tablesB
Listar todas as tabelas do schema do projeto.
Inputs: no named parameters.
list_usersB
Listar usuários do projeto.
Inputs: no named parameters.
loginB
Autenticar como admin do projeto. Retorna accessToken e refreshToken.
Inputs: email (required), senha (required), tenantSlug.
provision_projectB
Provisionar projeto completo com infraestrutura. Requer super_admin.
Inputs: nome (required), slug (required), adminNome (required), adminEmail (required), +1 more.
publish_projectB
Conectar repositório GitHub e iniciar deploy. Admin (dono) ou super_admin.
Inputs: slug (required), githubRepo (required), branch.
query_dataC
Buscar dados paginados de uma tabela.
Inputs: table (required), page, limit.
update_userC
Atualizar dados de um usuário do projeto.
Inputs: userId (required), nome, email.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 15 tools
Most tools are clearly distinct (e.g., list_tables vs get_columns vs query_data). However, create_project, list_my_projects, provision_project, publish_project, and deploy_status could be confused without careful reading of descriptions, especially around project lifecycle stages.
Tool names consistently use snake_case and follow a verb_noun pattern (e.g., login, get_service_token, list_tables, create_user). Minor inconsistency: 'login' lacks a noun object, but overall predictable.
15 tools is within the reasonable range (3-15) for a server covering authentication, project management, data querying, and deployment. Slightly on the higher side but each tool appears to serve a distinct purpose.
While the surface covers authentication, project info, table/column listing, data query, SQL execution, user CRUD, and project creation/deployment, there are gaps: no delete operations for users or projects, no update for projects, and no explicit get_project (only list_my_projects). These missing operations may cause dead ends for agents needing full lifecycle management.
Maintenance
Related MCP Connectors
Work with your database from AI tools: ask, export, approved changes, and scheduled jobs.
Query, explore, and manage your databases through natural conversation.
Your Supabase account in natural language: run SQL, apply migrations, manage tables, storage, edge f
AI agents propose database changes as reviewable requests — no direct write access.
Related MCP Servers
- AlicenseAqualityBmaintenanceAllows AI assistants to list tables, read data, and execute SQL queries through a controlled interface, making database exploration and analysis safer and more structured.315,299 PyPI1,418MIT
- FlicenseNot gradedqualityDmaintenanceEnables AI assistants to interact with PostgreSQL and Supabase databases through natural language. Supports secure database operations including queries, migrations, and schema management with user-provided credentials.1-
- AlicenseAqualityDmaintenanceEnables AI assistants to connect to and interact with PostgreSQL, MySQL, SQLite, and MongoDB databases through natural language, supporting schema exploration, query execution, data export, and more.13MIT
- AlicenseCqualityCmaintenanceEnables developers to inspect and modify SQL and NoSQL databases through natural language chat, without opening a dedicated database client.23MIT