Integration
Connect SQL Server to Meisterplan
When New or Updated Row fires in SQL Server, your agent runs Create or Update a Project's Tool Link in Meisterplan. Describe the whole flow and it is built, tested on every scenario and kept running.
What the catalog holds today. Ask for anything missing and your agent reads the API documentation and adds it.
Build solutions, not workarounds.
What do you want SQL Server and Meisterplan to do together?
Ask the assistant
Connect your AI client
Give your AI client this address.
https://mcp.apiant.aiOne connection does both: ask your client to act in an app once, or have it build an automation that keeps running. Any client that takes a remote MCP server. Nothing to install. Create your free account, then sign in once in your browser.
Set it up in your client
Claude Code
Run this in the directory you want to work in.
claude mcp add --transport http -s project apiant-ai https://mcp.apiant.aiStart Claude Code there, approve the server, and sign in in the browser page it opens.
Claude Code guide (opens in a new tab)Claude, web and desktop
Open Customize, then Connectors, then Add custom connector, and paste the address. On Team and Enterprise an owner adds it first.
Setup guide (opens in a new tab)Cursor
Add the address to your MCP configuration as a server URL. Cursor signs you in in your browser.
Setup guide (opens in a new tab)Zed
Open Settings, then AI, then MCP Servers, then Add Server, then Add Remote Server.
Setup guide (opens in a new tab)Codex and the ChatGPT desktop app
Open Settings, then MCP servers, then Add server, and choose Streamable HTTP. From the terminal, Codex takes the address with its own add command and then signs you in.
Setup guide (opens in a new tab)Any other MCP client
Paste the address where the client asks for a remote MCP server URL, and name the server apiant-ai where it lets you. APIANT's skills reach the client over the same connection.
Setup guide (opens in a new tab)Example flows
What SQL Server can start in Meisterplan
When New or Updated Row in SQL Server
then Create or Update a Project's Tool Link in Meisterplan
Starting points drawn from the triggers and actions in the catalog today. Describe the flow you need, at any depth, and your agent builds it and tests every scenario before it ships.
Everything your agent can do with SQL Server and Meisterplan
Triggers and actions 4 triggers · 42 actions
- New or Updated Row
Triggers when a new row is added or modified.
- New or Updated Row (Custom Query)
Fires for each new or changed row returned by a SELECT statement you write against the connected SQL Server database.
- New Row
Triggers when you add a new row.
- New Table
Fires when a new table appears in the connected SQL Server database.
- Add Row
Add one row to a table on the connected SQL Server database.
- Delete Row
Delete the rows in a table whose chosen column equals a value.
- Find Row
Find the first row in a table whose chosen column matches a value.
- Find Rows via Custom Query
Runs a SELECT statement you write against the connected SQL Server database and returns every row it matches.
- Find Row via Custom Query
Runs a SELECT statement you write against the connected SQL Server database and returns the first row it matches.
- Run Custom Statement
Runs a statement you write against the connected SQL Server database that changes data rather than returning rows, and reports how many rows it changed.
- Update Row
Change column values on every row of a table whose chosen column matches a value.
- Add milestone
Creates a milestone on a Meisterplan project in the chosen scenario and returns the new milestone.
- Add risk
Creates a risk on a Meisterplan project and returns the new risk.
- Add team
Creates a team in Meisterplan and returns the new team.
- Create or Update Actual Time Worked
Records the hours a resource or role actually worked on a project for a given date, updating the existing entry if one is already there. Returns the stored entry.
- Create or Update Allocation
Allocates a resource or role to a project for a date range, updating the existing allocation if one is already there. Returns the allocation with its resulting segments.
- Create or Update a Project's Tool Link
Links a Meisterplan project to the matching project in a task management tool, updating the link if one already exists. Returns the stored link.
- Create or Update Part-Time Working Model
Sets a resource's part-time working model by replacing its calendar deviations (relative capacity) for a time period. Returns the resource's resulting deviations.
- Create or Update Resource Absence
Records an absence for a resource over a date range, so the time is taken out of their availability. Returns the stored absence.
- Create or Update Tasks of a Project's Tool Link
Pushes a task from a linked task management tool onto a Meisterplan project, updating it if the task key is already there.
- Create Project
Creates a project in a Meisterplan scenario, including its dates, budgets and custom fields. Returns the new project.
- Create Resource
Adds a person to the Meisterplan resource pool, with their role, calendar, cost rate and org placement. Returns the new resource.
- Create Role
Creates a role in Meisterplan that resources can be assigned to and projects can be allocated against. Returns the new role.
- Delete project
Deletes a project from a Meisterplan scenario.
- Delete resource
Deletes a resource from Meisterplan. The run fails if no resource has the given id.
- Find a Resource or Role
Returns the resources and roles whose key, name or email matches the text you supply. Meisterplan has no server-side search on these collections, so the match is made after fetching them.
- Find a Team, Resource or Role
Returns the teams, resources and roles whose name, key or email matches the text you supply. Meisterplan has no server-side search on these collections, so the match is made after fetching them.
- Find Project by Key
Returns the project in a scenario that carries the project key you supply. Meisterplan has no server-side project search, so the match is made after fetching the scenario's projects.
- Find Project by Name
Returns the projects in a scenario whose name contains the text you supply. Meisterplan has no server-side project search, so the match is made after fetching the scenario's projects.
- Find Resource by Email
Returns the resource whose email address matches the one you supply. Meisterplan has no server-side resource search, so the match is made after fetching the resource pool.
- Find Resource by Key
Returns the resource carrying the resource key you supply. Meisterplan has no server-side resource search, so the match is made after fetching the resource pool.
- Find Role by Name
Returns the role carrying the name you supply. Meisterplan has no server-side role search, so the match is made after fetching the roles.
- Find Task by Key
Returns the task on a project's tool link that carries the task key you supply. Meisterplan has no server-side task search, so the match is made after fetching the project's tasks.
- Get project
Returns a single Meisterplan project in a scenario, including its custom fields.
- Get resource
Returns one Meisterplan resource by its id, including its role, calendar, skills, cost rates, team contributions and custom fields.
- List allocations
Returns every allocation of a project in a scenario, with the allocated role, resource or team and its time segments.
- List milestones
Returns all milestones of a Meisterplan project, including their custom fields.
- List programs
Returns the programs in a Meisterplan scenario, optionally narrowed to those matching a program key or name.
- List resources
Returns the resources (people) in your Meisterplan system, optionally narrowed by key, name, external id, email or address.
- List roles
Returns the roles in Meisterplan, optionally only those matching a name or external ID.
- List teams
Returns the teams in your Meisterplan system, optionally filtered by name or resource key.
- Update milestone
Updates an existing milestone on a Meisterplan project, changing only the details you supply.
- Update Project
Updates a project in a Meisterplan scenario — its dates, budgets, status and custom fields. Only the values supplied are changed. Returns the updated project.
- Update Resource
Updates a person in the Meisterplan resource pool — their name, role, calendar, cost rate and org placement. Only the values supplied are changed. Returns the updated resource.
- Update Role
Updates a role in Meisterplan — its name, cost rate and org placement. Only the values supplied are changed. Returns the updated role.
- Update team
Updates a team in Meisterplan, changing only the details you fill in.
No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.
Each app on its own
Reviews
What our customers say
More from SQL Server
SQL Server to StripeStripe is a payment processing platform for online businesses.
SQL Server to TrelloTrello is a visual collaboration tool that organizes projects into boards, lists, and cards.
SQL Server to JIRAAtlassian JIRA Cloud — issue tracking and project management.
SQL Server to ZoomZoom unifies cloud video conferencing, simple online meetings, group messaging, and a software-based...
SQL Server to TypeformBuild and publish online forms, surveys, and quizzes with Typeform.
SQL Server to WebflowWebflow is a professional website builder and CMS for designing, building, and launching responsive...
More into Meisterplan
PyPI to MeisterplanPackage metadata, release history and download files for any Python package published on the Python Package...
HubSpot to MeisterplanHubSpot is your all-in-one stop for all of your marketing software needs.
Salesforce to MeisterplanSalesforce is a leading enterprise customer relationship management (CRM) platform.
Slack to MeisterplanSlack is a messaging platform for teams. Post messages, manage channels, users, reminders, and react to...
Google Sheets to MeisterplanGoogle Sheets is Google's online spreadsheet app for creating, editing and sharing spreadsheets.
Gmail to MeisterplanGmail is Google’s email service, featuring spam protection, search functions, and seamless integration with...
Questions
SQL Server and Meisterplan, answered
What can start an automation from SQL Server?
Any of SQL Server's 4 triggers in the catalog, including New or Updated Row, New or Updated Row (Custom Query), New Row and New Table. Describe the moment in plain language and your agent picks the right one.
What can your agent do in Meisterplan when something happens in SQL Server?
Any of Meisterplan's 35 actions, including Create or Update Actual Time Worked, Create or Update Allocation, Create or Update a Project's Tool Link and Create or Update Part-Time Working Model. Your agent maps the data both ways and tests every scenario before it ships.
Can it also run from Meisterplan to SQL Server?
Meisterplan has no triggers in the catalog today, so automations start in SQL Server. If you need the other direction, ask: your agent reads Meisterplan's API documentation and adds it.
Do I have to build a connector for SQL Server or Meisterplan?
No. Both are in the catalog with their triggers and actions. You describe the automation; your agent builds it, tests every scenario and keeps it running.
Can my AI client use SQL Server and Meisterplan without building an automation?
Yes. With your AI client connected to APIANT, ask it to do something in either app once and it runs that action on the spot. Ask for an automation and your agent builds it, tests every scenario and keeps it running. One connection covers both.
What happens when something fails?
Your agent works that out for you. It plans the failure paths along with the happy path, then tests every scenario before it ships.
Is there a free plan?
Yes. Every plan includes the agent, including free, and building from your own AI client spends no assistant credits.