efcore.pg
Copilot instructions1.8k starsChanged 14 days agoPostgreSQLView on GitHub
This is the PostgreSQL provider for Entity Framework Core, built on top of Npgsql. It translates EF Core LINQ queries into PostgreSQL SQL and handles PostgreSQL-specific features like arrays, JSON,…
We split this copilot-instructions.md into the rules it gives an agent
5 rules. About 0 are common, 2 are distinctive, and 3 are very specific to this project.
≈0
Common · estimate
Many files like this have a rule of this kind.
≈2
Distinctive · estimate
This author's own choices. Worth a look.
3
Very specific
Tied to their project's names, files or tools. Probably skip.
Licensed with conditions — read it at the source. We count its rules but don't quote them. Read them on GitHub.
≈ “Common” is an estimate: at least 1 in 5 of the 3,669 Copilot instructions files we read have a rule of the same kind, not the same words. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.
Trending
More talk lately.about the whole repository
Who's talking about npgsql/efcore.pg
- dotnet/efcore“Translate LINQ DistinctBy”GitHub · Feb 18, 2022 · 155 reactions
- dotnet/efcore“Non-tracking ExecuteInsert”GitHub · Dec 19, 2022 · 131 reactions
- dotnet/efcore“Support inheritence with JSON POCO mapping”GitHub · Apr 7, 2022 · 99 reactions
- dotnet/efcore“Can't map Dictionary<string,object> (e.g. to JSON) since it's detected as a property bag”GitHub · Dec 6, 2021 · 61 reactions
- dotnet/efcore“Support expression (AKA functional) indexes”GitHub · Jul 2, 2022 · 52 reactions
The biggest 5 of 76 mentions linking to the repository that our crawl found. Each line is their own headline.
See all 76
Talked about on GitHub and Stack Overflow (76 times).
On GitHub · 50
- Feb 18, 2022Translate LINQ DistinctBy — dotnet/efcore155 reactions · 9 comments
- Dec 19, 2022Non-tracking ExecuteInsert — dotnet/efcore131 reactions · 9 comments
- Apr 7, 2022Support inheritence with JSON POCO mapping — dotnet/efcore99 reactions · 17 comments
- Dec 6, 2021Can't map Dictionary<string,object> (e.g. to JSON) since it's detected as a property bag — dotnet/efcore61 reactions · 11 comments
- Jul 2, 2022Support expression (AKA functional) indexes — dotnet/efcore52 reactions · 18 comments
45 more on GitHub
- Feb 3, 2022Support value-converted parameters in raw SQL — dotnet/efcore46 reactions
- Jul 16, 2021Shared column with different CLR types gets projected out twice — dotnet/efcore15 reactions · 6 comments
- May 23, 2023Consider a related entity loading strategy that aggregates dependent collections to a JSON array — dotnet/efcore11 reactions · 1 comment
- Oct 11, 2020Full support for custom provider aggregate functions — dotnet/efcore10 reactions · 6 comments
- Nov 28, 2023"Index was out of range" in ShaperProcessingExpressionVisitor.JsonEntityMaterializerRewriter — dotnet/efcore9 reactions · 14 comments
- Aug 21, 2022Json: allow customizing (some) serialization options when creating json, so that it's more readable — dotnet/efcore9 reactions · 3 comments
- Apr 15, 2022JSON: Support [JsonConverter] — dotnet/efcore9 reactions · 18 comments
- Jun 7, 2024Allow rotating usernames on NpgsqlDataSource in addition to passwords — npgsql/npgsql8 reactions
- Mar 14, 2022Closure references are represented as constant nodes in expression trees — dotnet/fsharp8 reactions · 11 comments
- Nov 24, 2020Builder method mismatch across providers in model snapshot — dotnet/efcore8 reactions · 12 comments
- Jul 4, 2026chore(deps): update nuget: npgsql update to 10.0.3 — escendit/aspnetcore-builder3 reactions · 1 comment
- Jun 13, 2026chore(deps): update nuget: npgsql update to 10.0.3 — escendit/aspnetcore-diagnostics-healthchecks2 reactions · 1 comment
- Jul 9, 2025Document translations for NodaTime LocalDate.{At,AtMidnight} — npgsql/doc2 reactions
- Oct 19, 20203.1.11: Add missing Ordinal to parameter StartsWith comparison — dotnet/efcore2 reactions · 1 comment
- Oct 14, 2026chore(deps): update dependency npgsql.entityframeworkcore.postgresql to v10 — thomhurst/Kevlar1 reaction · 4 comments
- Oct 1, 2026Bump the dotnet group with 9 updates — demortes/truckload-twitch-extension1 reaction · 1 comment
- Jun 22, 2026Bump Microsoft.AspNetCore.Authentication.JwtBearer and 5 others — PhantomDave/legendary-cashin1 reaction · 4 comments
- May 31, 2026chore(backend): Bump the backend-minor-patch group with 4 updates — kovacsmate3/collaboration-in-local-communities1 reaction · 1 comment
- May 31, 2026chore(backend): Bump the entity-framework-postgres group with 2 updates — kovacsmate3/collaboration-in-local-communities1 reaction · 2 comments
- Mar 17, 2025Bump NodaTime, Npgsql.EntityFrameworkCore.PostgreSQL and Npgsql.EntityFrameworkCore.PostgreSQL.NodaTime — wildsebastian/website1 reaction · 2 comments
- Mar 1, 2025chore(deps): update dependency npgsql.entityframeworkcore.postgresql to 9.0.4 — Belphemur/AddictedProxy1 reaction · 1 comment
- Jan 19, 2025chore(deps): update dependency npgsql.entityframeworkcore.postgresql to 9.0.3 — Belphemur/AddictedProxy1 reaction · 1 comment
- Nov 18, 2024chore(deps): update dependency npgsql.entityframeworkcore.postgresql to 9.0.0 — Belphemur/AddictedProxy1 reaction · 1 comment
- Sep 1, 2024Docs related to version 7 GUID generation — npgsql/doc1 reaction
- Aug 16, 2024Add different provider code samples for SqlQuery — dotnet/EntityFramework.Docs1 reaction
- May 18, 2024Remove hacky enum type mapping introspection — npgsql/npgsql1 reaction · 1 comment
- Jun 1, 2022Query: Remove TpcTablesExpression once pruning is done — dotnet/efcore1 reaction · 4 comments
- May 29, 2020v4.3.0 — tgstation/tgstation-server1 reaction · 1 comment
- Oct 28, 2026Bump Npgsql.EntityFrameworkCore.PostgreSQL from 10.0.1 to 10.0.3 — Ouarzy/warhammer-matchmaker0 reactions
- Oct 27, 2026Bump Npgsql.EntityFrameworkCore.PostgreSQL from 8.0.11 to 9.0.4 — revuimar/ActivityTracker0 reactions
- Oct 27, 2026Bump Npgsql.EntityFrameworkCore.PostgreSQL from 10.0.0 to 10.0.3 — waseemyounas-bit/OrderingSystem0 reactions
- Oct 24, 2026Bump Npgsql.EntityFrameworkCore.PostgreSQL from 8.0.11 to 9.0.4 — Barba350/GOZO0 reactions
- Oct 24, 2026Bump Npgsql.EntityFrameworkCore.PostgreSQL from 8.0.10 to 9.0.4 — Agostina19/ingsoft3-tp010 reactions
- Oct 24, 2026Bump Npgsql.EntityFrameworkCore.PostgreSQL from 8.0.10 to 9.0.4 — jats03/frontenis0 reactions
- Oct 23, 2026Bump Npgsql.EntityFrameworkCore.PostgreSQL from 8.0.4 to 9.0.4 — santiago6124/ingsoft3-turnos0 reactions
- Oct 21, 2026Bump Npgsql.EntityFrameworkCore.PostgreSQL from 8.0.4 to 9.0.4 — agussesin/ingsoft3-tp010 reactions
- Oct 21, 2026Bump Npgsql.EntityFrameworkCore.PostgreSQL from 8.0.4 to 9.0.4 — Geronimo2001/ingsoft30 reactions
- Oct 20, 2026Bump Npgsql.EntityFrameworkCore.PostgreSQL from 8.0.10 to 9.0.4 — 2319555-blason/ingsoft3-tp010 reactions
- Oct 20, 2026Bump Npgsql.EntityFrameworkCore.PostgreSQL from 9.0.4 to 10.0.3 — conradovolpi/ingsoft3-tp010 reactions
- Oct 19, 2026Bump Npgsql.EntityFrameworkCore.PostgreSQL from 8.0.11 to 9.0.4 — SneiderM2/LMS_PRIMARIA0 reactions · 1 comment
- Oct 19, 2026Bump Npgsql.EntityFrameworkCore.PostgreSQL from 8.0.4 to 9.0.4 — cavacofml-alt/ahm-audit0 reactions
- Oct 11, 2026Bump Npgsql.EntityFrameworkCore.PostgreSQL from 8.0.11 to 9.0.4 — NikshayMungal/cloudicetask0 reactions
- Oct 10, 2026Bump Npgsql.EntityFrameworkCore.PostgreSQL from 10.0.1 to 10.0.3 — nhatminh16704/pc-part-market0 reactions
- Oct 8, 2026Bump Npgsql.EntityFrameworkCore.PostgreSQL from 8.0.11 to 9.0.4 — arielsch74/practica-tp70 reactions
- Oct 3, 2026Bump Npgsql.EntityFrameworkCore.PostgreSQL from 8.0.11 to 9.0.4 — Alvindag/cirg0 reactions
On Stack Overflow · 26
- Mar 31, 2021Npgsql in EFCore cannot translate DateTimeOffset.Date6 votes
- Jan 14, 2020Entity Framework Core `HasConversion` property configuration not used when querying data with postgresql5 votes · 1 answer
- Nov 18, 2021Log notices with Npgsql and EF Core3 votes
- Jul 27, 2022Running Update-Database in a database with multiple EF managed schemas2 votes
- Feb 6, 2023How to alter Entity Framework column to jsonb with USING?1 vote · 1 answer
21 more on Stack Overflow
- Jan 17, 2023Can't cast database type xid8 to Int641 vote
- Feb 15, 2022Npgsql.PostgresException: type "ltree" does not exist1 vote
- Dec 20, 2021Constant tables in EF or Npgsql1 vote
- Oct 6, 2021EF PostgreeSQL array_append1 vote
- Jun 11, 2021How to explicitly set the ID property on an autoincrementing table in EFCore1 vote
- Jun 8, 2021EF Core 5 translate jsonb field null check to false constant1 vote
- Oct 16, 2020How to query against a column that has a JSON Array in Npgsql.EntityFrameworkCore1 vote
- Sep 10, 2020How can I use postgresql reverse function with EFCore1 vote
- Aug 13, 2020How to compare money data with Npgsql EF Core?1 vote
- Jan 28, 2020Query the length of a bytea value from PostgreSQL with EF Core1 vote
- Dec 19, 2019Mapping geometries with EF Core 2.2, Npgsql and NetTopologySuite1 vote · 1 answer
- Nov 25, 2019Is there a Postgres array overlap (&&) operator for EF Core 3.0 Npgsql1 vote
- Feb 18, 2025How tu mock EF.Functions.ILike during Unit Tests by EF's user defined function mapping0 votes
- Jul 15, 2024System.InvalidCastException: Can't cast database type timestamp without time zone to DateOnly0 votes · 1 answer
- Nov 25, 2022How to Stop the Entity Framework Code First from running “CREATE SCHEMA IF NOT EXISTS”0 votes
- Jul 6, 2022Getting an error( Npgsql.PostgresException: '42601: syntax error at or near "[" ) when I use WebSecurity.InitializeDatabaseConnection(parameters)0 votes
- Dec 18, 2021How to reverse engineer Postgres 9.0 database0 votes
- Mar 28, 2020OwnsOne drops IDENTITY from tables key0 votes
- Mar 23, 2020EF Core Postgres DbUpdateConcurrencyException when updating detached data0 votes
- Jan 17, 2020How to filter datetime with three fields day,month,year in EF Core and Postgresql0 votes
- Dec 11, 2019value too long for type character varying(25)0 votes
Where files are headingNew Copilot instructions files have more rules about branches and pull requests, and fewer about code style.
Of the Copilot instructions files we read, the 2,297 first seen in the last six months, against the older ones: the kind of rule that gained most share, and the kind that lost most. About files like this in general, not this one, and an estimate, since a kind is a pattern in the words.
In this repository2 other files it gives its agents.
- sync-to-latest-efSkill
- triageSkill
Does it work?
Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.
No reviews yet
People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.
- It worked
- Partly
- It didn't
Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.
Your trail
Files you open will collect here, so you can find them again.
Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.
Now do this for your own.
Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.

