I will design your postgresql database schema with a clear erd diagram
PostgreSQL and Database Engineer
About this Gig
A good schema saves you months of trouble later. A weak one shows up as duplicate data, slow reports and tables nobody wants to touch.
I have worked with databases for 10 years, mostly in banking and the public sector: data warehouses, reporting tables and app databases on PostgreSQL, Oracle and SQL Server.
What you get:
- Tables, columns and data types that fit your data
- Primary and foreign keys, constraints and indexes
- Normalized design, without overcomplicating it
- A clear ERD diagram (PNG or PDF)
- A SQL script you can run to create everything
What I need from you: a short description of your app or business process, the main things you store (customers, orders, products, etc.) and any schema you already have. A rough list or a spreadsheet is fine.
For PostgreSQL I can also add roles and row level security. Message me first if you are unsure about the size.
Database type:
Relational database
Platform:
MS SQL
•
Oracle
•
PostgreSQL
•
SQL Server
Expertise:
Data structure
•
Design
•
ERD
•
Normalization
Other Databases Services I Offer
FAQ
Can you review a schema I already have?
Yes. Send the SQL or a screenshot of your tables, and I will send back written fixes: keys, relations, indexes and naming.
Do you only work with PostgreSQL?
PostgreSQL is my main choice for new projects, but I also design schemas for Microsoft SQL Server and Oracle.
In what format do I get the ERD?
You get the diagram as PNG and PDF, plus the source file so you can edit it later, and a SQL script you can run on your database.
