Skip to content
  • Home
  • About
  • No Access
  • Privacy Policy
Bits of .NET
Bits of .NET
  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy

Bits of .NET

Daily micro-tips for C#, SQL, performance, and scalable backend engineering.

  • Asp.Net Core
  • C#
  • SQL
  • JavaScript
  • CSS
  • About
  • ErcanOPAK.com
  • No Access
  • Privacy Policy
AI

AI Prompt: Generate JSON Schema from Sample Data

- 06.06.26 - ErcanOPAK

📋 Generate Validation Rules from Example JSON

Writing JSON Schema by hand is painful. AI generates schema from examples. Infer types, required fields, patterns, constraints.

📝 The Prompt

Generate a JSON Schema (draft-07) from these example objects:

Examples:
[{{"id": 1, "name": "Alice", "email": "alice@example.com", "age": 30}},
 {{"id": 2, "name": "Bob", "email": "bob@example.com", "age": 25}},
 {{"id": 3, "name": "Charlie", "email": "charlie@example.com", "age": 35}}]

Requirements:
- Infer required fields (fields present in all examples)
- Infer types (string, number, boolean, array, object)
- Add format validations (email, date-time, uri)
- Add range constraints for numbers (min, max)
- Add length constraints for strings (minLength, maxLength)
- Add enum if field has limited distinct values
- Add additionalProperties: false
- Include descriptions for each field

Output as valid JSON Schema.

✅ Example Output

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "type": "object",
  "required": ["id", "name", "email", "age"],
  "properties": {
    "id": {
      "type": "integer",
      "description": "Unique identifier",
      "minimum": 1
    },
    "name": {
      "type": "string",
      "description": "Full name of the user",
      "minLength": 1,
      "maxLength": 100
    },
    "email": {
      "type": "string",
      "format": "email",
      "description": "Email address"
    },
    "age": {
      "type": "integer",
      "description": "Age in years",
      "minimum": 0,
      "maximum": 150
    }
  },
  "additionalProperties": false
}

💡 Use Cases

  • API request/response validation
  • Database schema documentation
  • Configuration file validation
  • Data migration quality checks
  • Generate TypeScript interfaces from JSON

“Had 50MB of JSON data from legacy API. Generated schema in seconds. Found that ‘age’ was sometimes string. Fixed API. JSON Schema generation saved days of manual validation.”

— API Architect

Related posts:

AI Prompt: Generate Competitive Analysis Report

AI Prompt: Generate Competitive Analysis Report

AI Prompt: Crafting a Viral Technical Newsletter in Seconds

AI Prompt: Crafting a Viral Technical Newsletter in Seconds

The AI Prompt That Finds Feature Flags Nobody Remembers to Remove

The AI Prompt That Finds Feature Flags Nobody Remembers to Remove

Views: 11

Post navigation

Docker: Use Distroless Images for Maximum Security
Windows 11: Use Quick Assist to Help Friends and Family Remotely

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

November 2026
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
30  
« Oct    

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,068)
  • Get the User Name and Domain Name from an Email Address in SQL (990)
  • How to add default value for Entity Framework migrations for DateTime and Bool (986)
  • Get the First and Last Word from a String or Sentence in SQL (865)
  • How to select distinct rows in a datatable in C# (859)
  • How to enable, disable and check if Service Broker is enabled on a database in SQL Server (661)
  • Add Constraint to SQL Table to ensure email contains @ (619)
  • Average of all values in a column that are not zero in SQL (577)
  • How to use Map Mode for Vertical Scroll Mode in Visual Studio (553)
  • Find numbers with more than two decimal places in SQL (481)

Recent Posts

  • Network Speed Monitor Windows Application v2.5.1
  • Ağ Hızı İzleyici Windows Uygulaması v2.5.1
  • How to make theater mode the default for Youtube
  • The AI Prompt That Audits a Function for Thread-Safety Gaps
  • Ajax: Fix a Fetch Request Caching a Response Despite No-Store
  • WordPress: Fix a Navigation Block Losing Submenu Items After Sync
  • Visual Studio: Fix CodeLens Reference Counts Stuck at Stale Numbers
  • C#: Fix a UTF-8 String Literal Behaving Differently in a Switch
  • Photoshop: Fix a Liquify Mesh Snapping Back on a Smart Object
  • The AI Prompt That Turns a Crash Dump Into a Short Repro Script

Most Viewed Posts

  • How to make theater mode the default for Youtube (1,068)
  • Get the User Name and Domain Name from an Email Address in SQL (990)
  • How to add default value for Entity Framework migrations for DateTime and Bool (986)
  • Get the First and Last Word from a String or Sentence in SQL (865)
  • How to select distinct rows in a datatable in C# (859)

Recent Posts

  • Network Speed Monitor Windows Application v2.5.1
  • Ağ Hızı İzleyici Windows Uygulaması v2.5.1
  • How to make theater mode the default for Youtube
  • The AI Prompt That Audits a Function for Thread-Safety Gaps
  • Ajax: Fix a Fetch Request Caching a Response Despite No-Store

Social

  • ErcanOPAK.com
  • GoodReads
  • LetterBoxD
  • Linkedin
  • The Blog
  • Twitter
© 2026 Bits of .NET | Built with Xblog Plus free WordPress theme by wpthemespace.com