# Amazon DynamoDB vs PostgreSQL: which do AI models recommend for nosql, October 2026

IT AI Recommendation Index, October 2026 Edition, NoSQL databases. One of fourteen models named Amazon DynamoDB first on the direct prompt; zero named PostgreSQL. Page: https://it-ai-index.com/it-data/nosql-databases/amazon-dynamodb-vs-postgresql/

| | First-choice share | Rank | Negative rate | Labels | Models naming it |
|---|---|---|---|---|---|
| Amazon DynamoDB | 11% | #2 of 13 | 21% | 67 | 14 of 14 |
| PostgreSQL | 2% | #6 of 13 | 0% | 11 | 9 of 14 |

## The direct prompt, model by model

- Mistral Small: amazon dynamodb first (first choices: Amazon DynamoDB, MongoDB) (alternatives: Azure Cosmos DB, Redis)
- Claude Haiku 4.5: neither first, one named (first choices: MongoDB) (alternatives: Amazon DynamoDB, Google Cloud Firestore, PostgreSQL with JSON)
- GPT-5.4 mini: neither first, one named (first choices: MongoDB) (alternatives: Amazon DynamoDB, Apache Cassandra)
- Gemini 3.5 Flash: neither first, one named (first choices: MongoDB) (alternatives: Amazon DynamoDB, Couchbase)
- Perplexity Sonar: neither first, one named (first choices: MongoDB) (alternatives: Amazon DynamoDB, Azure Cosmos DB)
- Grok 4.1 Fast: neither first, one named (first choices: MongoDB) (alternatives: Amazon DynamoDB, Apache Cassandra)
- DeepSeek V4 Flash: neither first, one named (first choices: MongoDB) (alternatives: Amazon DynamoDB, PostgreSQL)
- Qwen 3.7 Flash: neither first, one named (first choices: MongoDB) (alternatives: Amazon DynamoDB, Neo4j, PostgreSQL)
- GLM 4.7 FlashX: neither first, one named (first choices: MongoDB) (alternatives: Amazon DynamoDB, Apache Cassandra, Couchbase)
- MiniMax M2.5: neither first, one named (first choices: MongoDB) (alternatives: Amazon DynamoDB, Couchbase)
- GPT-6 Luna: neither first, one named (first choices: MongoDB) (alternatives: Amazon DynamoDB, PostgreSQL)
- Muse Glimmer 30B: neither first, one named (first choices: MongoDB) (alternatives: Amazon DynamoDB)
- Llama 4 Maverick: neither named (first choices: MongoDB)
- Kimi K2: neither named (first choices: MongoDB) (alternatives: Couchbase)

## What the models said about Amazon DynamoDB

- "Avoid DynamoDB as a primary application database unless your use case is a clean fit for key-value patterns" (Kimi K2, direct prompt, hard negative)
- "Avoid DynamoDB unless you are deeply invested in AWS" (GLM 4.7 FlashX, paraphrase prompt, hard negative)
- "AWS guidance says to avoid large items, reads on non-key attributes, and scans, which means it can be a poor fit if your access pattern is not key-centric" (Perplexity Sonar, negative prompt, soft negative)
- "I'd typically recommend starting with a managed document database (MongoDB Atlas or DynamoDB) if you want flexibility" (Claude Haiku 4.5, paraphrase prompt, first choice)
- "DynamoDB is a pragmatic default because it gives you managed key-value performance with document-style JSON values" (Muse Glimmer 30B, paraphrase prompt, first choice)
- "Amazon DynamoDB – #1 of 31 tools in a 2026 round-up, and listed as best managed key-value at scale" (Muse Glimmer 30B, comparative prompt, first choice)

## What the models said about PostgreSQL

- "Before choosing any NoSQL database, ask yourself: "Why can't I use PostgreSQL?"" (Gemini 3.5 Flash, negative prompt, first choice)
- "If your data is highly normalized and relational ... stick to Postgres." (Qwen 3.7 Flash, scale prompt, first choice)
- "modern trends suggest looking at PostgreSQL (specifically with JSONB) as the ultimate hybrid solution" (Qwen 3.7 Flash, direct prompt, alternative)

Share is the count of first choices across the direct, paraphrase, budget and scale prompts over all fourteen models, for a mid-market B2B company; rank is within the category. Comparisons are drawn for the top eight products in each category. Published under CC BY 4.0; the output is the models' output, and nothing here is a recommendation by the index.