Design database schemas and APIs from requirements

Developers create database schemas and APIs from requirements

Ready to goAI Act: no extra obligationsCreating software & codeIT & software

Fits: IT & software development

Requirements turn into a first draft of tables, constraints and API description in minutes, along with open questions. You discuss a concrete draft instead of a blank page.

Is this for you?

  • You start new services or features and have so far written schemas and APIs by hand.
  • Requirements exist as text, tickets or meeting notes.
  • Someone with experience in databases and APIs checks the draft.
First step today

Write down a small business requirement in five sentences, for example a course booking with limited places, and use the template below to have a schema and test cases designed. Load the schema into a local test database and run the test cases.

How to go about it

  1. Write down requirements as business rules
  2. Define the database, API format and test environment
  3. Have the schema and API designed
  4. Check with test cases and concurrent access
  5. Roll out as a migration via the test pipeline
  6. Document and maintain decisions

Templates to copy

Try it now
in the training
Analyse
in the training
Plan the rollout
in the training
Included in the training

The complete guide

  • 6 steps explaining exactly what to do
  • 3 proven templates to copy into your own AI
  • Safe use: data, checking, deciding, informing
  • Pitfalls, effort and how to recognise success

With the training you get all 430 guides for as long as your access runs.

See the trainingOne-off per person, no subscription

Same approach, other use cases

13 more use cases follow the pattern “Creating software & code”.

Analyse measurement data with AI-written codeBuild forms and internal tools by describing themGenerate clickable prototypes from sketches and descriptionsHave AI review code and write testsHave AI write small scripts without coding skillsWrite code with AI assistance in the editorGenerate realistic test data without real customer dataHave AI document legacy systems and old codeHave AI generate test cases for control unit softwareHave AI players test games for bugsMigrate legacy applications to new languages with AIQuery databases in everyday language
‹ PreviousSee all use casesNext ›

IT-05 · Legal status 08.10.2026