{"name":"io.github.vpatser1/mcp-schema-designer","slug":"vpatser1-mcp-schema-designer","title":null,"description":"Design database schemas from natural language, validate SQL, generate migrations and types","url":"https://mcp.market/server/vpatser1-mcp-schema-designer","rating":null,"grade":"C","score":55,"certified":false,"status":"active","category":"data","tags":["data","media"],"presence":{"score":10,"stars":null,"forks":null,"downloads_week":24,"last_push_at":null,"license":"MIT"},"uptime":null,"claimed":false,"transport":"npm","callable_via_gateway":false,"default_price_micros":0,"repository":null,"website":"https://aivp-mcp.vercel.app","version":"1.1.4","remotes":[],"packages":[{"registryType":"npm","registryBaseUrl":"https://registry.npmjs.org","identifier":"mcp-schema-designer","version":"1.1.4","transport":{"type":"stdio"},"environmentVariables":[{"description":"License key (emailed after purchase at https://aivp-mcp.vercel.app). Omit for the free trial (3 calls per tool).","isSecret":true,"name":"LICENSE_KEY"}]}],"tools":[{"name":"design_schema","description":"Design a database schema from a natural language description. Generates CREATE TABLE SQL (PostgreSQL), index recommendations, and a text-based ERD. Optionally accepts explicit table definitions to validate and enhance.","write_action":false,"price_micros":0,"input_schema":null},{"name":"generate_types","description":"Generate typed code from SQL CREATE TABLE statements. Supports three output formats: TypeScript interfaces, Zod validation schemas, or JSON Schema definitions.","write_action":false,"price_micros":0,"input_schema":null},{"name":"migrate_schema","description":"Generate migration SQL by diffing a \"from\" schema against a \"to\" schema. Produces ALTER TABLE statements in safe dependency order, rollback SQL, and warnings for destructive changes (column drops, type changes).","write_action":false,"price_micros":0,"input_schema":null},{"name":"optimize_queries","description":"Analyze a SQL query against a schema and suggest performance improvements. Identifies missing indexes, recommends query rewrites, and provides EXPLAIN plan interpretation hints.","write_action":false,"price_micros":0,"input_schema":null},{"name":"validate_schema","description":"Validate SQL CREATE TABLE statements for best practices. Checks for missing primary keys, unnamed constraints, missing FK indexes, data type issues (e.g. TIMESTAMP vs TIMESTAMPTZ), naming conventions (snake_case, plural tables), and N+1 query risks.","write_action":false,"price_micros":0,"input_schema":null}],"scan":{"score":55,"grade":"C","scanned_at":"2026-09-24T05:07:45.070Z","report":{"scannerVersion":"0.1.9","scannedAt":"2026-09-24T05:07:45.037Z","components":{"code":{"score":25,"max":25,"notes":["19 source files scanned"]},"reliability":{"score":-1,"max":20,"notes":["no gateway calls yet and no remote to probe"]},"poisoning":{"score":-1,"max":15,"notes":["tools not inspected (local package is not executed); not counted"]},"auth":{"score":6,"max":15,"notes":["static API keys via environment variables"]},"maintenance":{"score":3,"max":15,"notes":["repository not readable: repo not found"]},"identity":{"score":2,"max":10,"notes":["no repository or website to verify"]}},"findings":[],"inputs":{"packages":[{"registryType":"npm","identifier":"mcp-schema-designer","version":"1.1.4","found":true,"license":"MIT","hasInstallScripts":false,"dependencyCount":2,"publishedAt":"2026-08-04T07:35:23.618Z","repositoryUrl":"git+https://github.com/vpatser1/mcp-servers.git","weeklyDownloads":24}],"repo":{"found":false,"owner":"vpatser1","repo":"mcp-servers","error":"repo not found"},"icon":{"url":null,"source":"none"},"presence":{"stars":null,"forks":null,"downloadsWeek":24,"license":"MIT","lastPushAt":null,"score":10}}}},"grade_history":[],"reviews":[]}